Forum Discussion
Power BI Service Refresh Fail - SharePoint: Request failed, DataSource.Error; (works from HardDrive)
I've slowly walked through the Power Query steps and identified which step wascausing the problem. The issue stemmed from where I was trying to perform a LEFTJOIN of a merged table from the Excel file with a table from a MySQL database, which was being accessed through an On-Premise Gateway I setup. Originally since I was accessing the Excel file found my hard through that same gateway, that’s probably why there wasn’t an issue before.
After some tinkering, I managed to fix the issue after reading this Topic Post; Under Gateway Cluster Settings, select Allow user's cloud data sources to refresh through this gateway cluster > Apply
HI Anonymous ,
Well done on finding the solution. Can you mark your post as solved so that we can use the information in the future if needed and so that folks don't try to give you answers when you already have them. 🙂 Thanks.