Forum Discussion
Merge Excel and SQL error refresh on Power BI service
Hi,
I have an issue with the refresh on the service.
I have this issue when I try to merge data from Excel (Sharepoint) and Sql.
If I try to delete the merge and refresh the simple source, it's good. When I use merge in Edit Query, it refresh normaly in desktop and it give me error when I try to refresh from Service. The problem is the different gateway ?
2 Replies
bali1879 Have you got the solution for this? I have the same experience even so many years after you, when there is a SharePoint Online List merge with a SQL Query in power query, powerbi service rerurn error that Cloud data source setting is not allowed refresh through gateway.
Hi bali1879 ,
Have you kept this option selected?
Please refer to this article: Merge or append on-premises and cloud data sources.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
