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 ,
What type of credentials are you used on this data source? Some authorization modes do not fully work on service side, I'd like to suggest you switch to 'organization account' mode and try again.
In addition, have you tried to update datasoruce credentials on power bi service side?
Regards,
Xiaoxin Sheng
Hello Anonymous, yes, we use Organization Account. I tried all my access to Dynamic 365 and the connection doesn't work through the API in PowerBI Service, it works in PowerBI Desktop though.
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?