refresh excel spreadsheets with on prem data connections
We have created a Sharepoint site on Office 365 however our data is all on prem. I need a way to be able to refresh Oracle and SQL server connections that are embedded into Excel spreadsheets. We already have Powerbi Gateway running as well as some users that have pro licenses. I'm wondering can this all go through the Powerbi gateway or does it require for all users to have a pro license in order to be able to refresh. I also have users that would like to be able to refresh from One Drive. Anyway please let me know your thoughts.
SharePoint Online - Embed Power BI Reports
Hi SPO Team, I have hundreds of power bi reports that I need to embed into the SharePoint online site. In Azure AD, four security groups have been created, so we can maintain the site access. Do I need to create a hundred separate SharePoint pages to include those reports? Also, is it necessary to create four separate SPO Teams sites based on the security groups, or can it be done in a single SPO Teams site, so the O365 users can access those reports? Thanks.