Forum Discussion
Dataflow: cannot add/use Excel from SharePoint when using on-premise SQL Server
I have an existing dataflow retrieving data from an on-premise SQL Server through a data gateway. Now I want to add a query that retrieves data from an Excel file stored in a SharePoint location. I ...
Hi I think this might help. Go to Manage Gateways in Power Bi Service and activate the checkbok in step 3.
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloud
If you want to refresh or merge cloud and on premise data you need this options activated.
Hope it helps.
Thanks for the reaction.
This option is already checked and works for the datasets that get their data 'directly' from the gateway, both SQL Server and Excel SharePoint queries. Within the dataflow however I cannot sign in with the Organizational Account option for Excel SharePoint queries. I can however sign in to another dataflow that only gets its data from Excel files stored on SharePoint. But that is the workaround I want to avoid.