Service Error - Need Help Please!

[ritaok]

Hello PowerBi Experts, 

I have following this issue can someone please guide how to solve this issue in service.

I currently have my data connected through 3 sources: SQL, Sharepoint and Odata (for my HRIS system). And during refresh i keep getting this error message. I read other posts that recommended adding sharepoint as a gateway but is that applicable in this case since i have a 3rd connection. 

I appreciate the guidance 

[Olufemi7]

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.

[lbendlin]

You should not merge on-prem and cloud data sources.

If you really have to , go to the gateway settings and "allow cloud data sources to be refreshed through this gateway"

But really, don't do it.  There is no need for a gateway for cloud connections.