Comments
Hi All,
I am getting this same error message after connecting my datasources to the On-premise Gateway for other sources in the report.
The SharePoint datasource is giving me the error "SharePoint: Request failed: Unable to connect to the remote server" when I initialize a refresh from the Power BI service or when i schedule a refresh through the Gateway.
If i initialize a refresh through the Power BI Desktop, it works perfectly fine.
Also it does not complain about the file that I am loading but complains about the another table where I am merging the SharePoint file with another file
All the steps mentioned in this document has been performed and still the same error message.
Please if you can help.
Thanks
We also tried refreshing datasets which merge on-prem source (SQL server) and online source (Excel on SharePoint online), and this is still not working, despite enabling the Gateway setting “Allow user’s cloud data sources to refresh through this gateway cluster.”
Hi,
It doesn't work with SharePoint Online et SQL Server On-premise.
Refreshing datasets containing queries that merge data from a web source with an on-Prem source still does not work. The linked documentation describes a procedure that doesn't solve the problem. This is not finished an marking it as "completed" is wrong.
I ran a couple of tests and documented them in an issues post where people can vote for it:
https://community.powerbi.com/t5/Issues/Gateway-data-refresh-fails-when-data-is-merged-from-web-and-on/idi-p/594579#M36791
This is frustrating, we've been waiting for this fix for more than a year!
It's convenient this is marked complete, when it doesn't fully work. I opened a support request trying to trace this issue and was sent tracing in circles providing logs and network traffic captures to no avail.
Has anyone found any workaround for this? It is crippling my ability to publish our latest dataset since migrating to using CSV files in Sharepoint to filter and augment database results
This is a major flaw in Power BI Gateways. Please fix this asap.
I have just come up against this problem. One year on from starting it still seems to be a major issue. Please fix this one MS.
I'm running into the same issue. Can someone please provide an update?
In the settings for the On-Premises Data Gateway, there's an option to “Allow user’s cloud data sources to refresh through this gateway cluster.” You can see that option shown on the 2nd screenshot on this page: https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud. Hopefully that option will help some of the people still commenting on this being an issue.
Administrator on 4/25/2023 11:33:37 PM
Was finished a while back...marking as finished https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud