Forum Discussion
Use a data gateway - greyed out
How do you split a data set in two? I have a report that has the following:
- CSV files stored on Sharepoint
- SQL Server tables
I want this to automatically refresh but the data gateway option is greyed out. How do I split it in the PowerBI report so the SQL data is updated?
The report was created in PowerBI Desktop.
edhans this is the same problem that I have.
It would seem impossible to have powerBI online to refresh a data source through the gateway that uses 2 data sources from different technologies.
I cannot find a way of building a report with data from 2 different datasets so there is no way of getting the SQL server queries "ring fenced" so that the data gateway is not greyed out.
This is really frustrating because it means one of the major capabilities of PowerBI, i.e. how to combine data in Excel with SQL in a data model, can only be refreshed from the Desktop version of PowerBI and the republished. As a result I have to refresh and republish stuff every day manually..
v-caliao-msft you mention a way of using two "sub datasets" but I cant see how you do this?
FWIW - this is now being worked on. https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13405644-combine-enterprise-gateway-and-online-data-sources