Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Use a data gateway - greyed out

I have created a simple report with one SQL connection that works fine through our Enterprise Data Gateway. If I add another dataset, this time from Excel file stored in Office 365 Sharepoint, then ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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?