Forum Discussion
Refreshing an oData source dataset and an on premise SQL dataset on the same gateway
Hello,
I made a report with some dataset connected to our on premise SQL server from PowerBI Desktop and I added a connection to Dynamic365 cloud with the OData connection with the link provide...
Ok, my boss figured it out. You need to leave as optional the cloud source and not add it to the gateway in order for the refresh to work.
here are source where we got the information:
https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud
Disregard the version of the data gateway, I just updated the version to 242 and it still doesn't work.
Ok, my boss figured it out. You need to leave as optional the cloud source and not add it to the gateway in order for the refresh to work.
here are source where we got the information:
https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud