Forum Discussion
Service Error - Need Help Please!
Hi ritaok,
Thanks for the update.You’re on the right track.Mixing on-prem sources (via gateway) with cloud sources (especially personal cloud connections) can sometimes cause refresh issues due to credential or connection context mismatches.
Since you’ve updated the connections (standard cloud connection + proper mapping), you can try triggering a refresh again and check if the issue still persists. Also, please ensure all sources are using consistent authentication (organizational account).
For more details, please refer to below documentations:
https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem
https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloudPlease let us know how it goes.
Thank you!
Hello ritaok,
You’re mixing SQL on a gateway with SharePoint and OData in the cloud, and the OData connection is set up as a personal cloud connection. That can cause refresh to fail when multiple sources are involved.
Recreate the OData connection as a normal cloud connection (not personal), sign in with your org account, and then remap it in the dataset settings.
Then just double check all sources are mapped and using the same type of credentials.
Good morning, and thank you for your response Olufemi7 !
I made the update below to create a gateway for SharePoint and switched OData from a personal connection to the standard cloud connection. Is that the right approach?
Thank you!
Hi ritaok,
Thanks for the update.You’re on the right track.Mixing on-prem sources (via gateway) with cloud sources (especially personal cloud connections) can sometimes cause refresh issues due to credential or connection context mismatches.
Since you’ve updated the connections (standard cloud connection + proper mapping), you can try triggering a refresh again and check if the issue still persists. Also, please ensure all sources are using consistent authentication (organizational account).
For more details, please refer to below documentations:
https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem
https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloudPlease let us know how it goes.
Thank you!
