Forum Discussion
Problems Refreshing on Service
Hi All, Im having the following problem. Im getting a refresh error on the service while on the desktop version its working well. I have two main data sources. - Analysis services cube - Sh...
Hi Anonymous
I believe below official document could be helpful:
https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud
Also, Make sure privacy levels for both cloud and on-premises data sources are set appropriately to ensure the joins are handled securely.
Hi Gilbert,
In Gateway section i have a red x on sharepoint. so im assuming it is not connecting. Although sharpoint is showing as not connected in gateway when both data sources are not appended together, Everything refreshes without issue on service. do you know why its happening and how i can fix?
Thank you
GilbertQ
Super User
Super UserHi there
What happens is when you are trying to merge 2 different data sources where one is cloud based and one is On-Prem it has to do all this via the Gateway.
So you will need to create a data source in the Power BI Service Gateway to your Sharepoint site. This will then give you the option to connect.
What happens is when you are trying to merge 2 different data sources where one is cloud based and one is On-Prem it has to do all this via the Gateway.
So you will need to create a data source in the Power BI Service Gateway to your Sharepoint site. This will then give you the option to connect.