Forum Discussion
Merged Queries working with the Data Gateway
I have 2 queries, one is an Excel file one is a SQL ODBC query. I can publish both easiliy and the data gateway can refresh both. However, if I merge them in Power BI Desktop to create a mergerd...
Hi,
I realise this is an old thread but it's the one I found when searching for merging queries between gateway and cloud (SQL Server and Salesforce in my case) and it doesn't have the solution that worked for me. I had to go into the gateway cluster settings in the PBI web service and tick the box to allow cloud data sources to refresh through the gateway.