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-cloud

Please let us know how it goes.

Thank you!