Forum Discussion
Refreshing an oData source dataset and an on premise SQL dataset on the same gateway
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
Hi Anonymous ,
I'd like to suggest you check and update your data source credentials on gateway side to confirm if they correct verified on power bi service.
If they all work, you can check your database rule and policy settings to confirm if they block power bi requests. BTW, you can also update your gateway to last version if this issue is related to gateway compatibility.
Regards,
Xiaoxin Sheng
We updated our datagateway and it still doesn't work.
It seems this was an issue for other people too:
Is our data gateway setting wrong?
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