Forum Discussion
Use Power BI as Data Source for Excel and Utilize Data Gateway
Hi Anonymous
Could you please describe more details about your scenario? Based on your description, it seems that you want to connect to on-Premise data source from SharePoint Online and fail to refresh the data. If that is the case, I would recommend you post the question in the Microsoft Online: SharePoint Online forum at https://social.technet.microsoft.com/Forums/msonline/en-US/home?forum=onlineservicessharepoint . It is appropriate and more experts will assist you.
In addition, as far as I know, besides using “Analyze in Excel” feature, there is no other method that can be used to connect to the Data Gateway data source in Excel.
Thanks,
Lydia Zhang
I can defintely post there. The reason that I posted here is that it appears this ability is directly related to the Data Gateway.
As seen on this post: https://support.office.com/en-us/article/Use-external-data-in-workbooks-in-SharePoint-Online-8d7f5dc6-8384-4d7d-b00f-b283c1e192ef
The last line is what I am trying to achieve:
- 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)
As it uses Power BI I was why I started here.