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