Forum Discussion
Use Power BI as Data Source for Excel and Utilize Data Gateway
GOAL: Refresh Excel data in SharePoint Online through Excel in web part or Excel Services web page (not opening in Excel client) connected to on-premises data source. I have set up a Data Gateway...
According to the TechNet article https://technet.microsoft.com/en-us/library/dn879362.aspx the new Data Gateway should support the overall data access needs for Excel and Office 365.
I will be trying to implement this durning the next 2 weeks.
Tried the latest gateway software and had the same issue. Anyone know when this will be made available and could elaborate on what the following means for the gateway
- SQL Server data that is available in the Power BI Admin Center (this requires a subscription to Power BI for Office 365 and an administrator to configure the connection)