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, thanks for taking time to look at this. Here is the error I get-
Again, I can create a query from either the file or the ODBC connection alone, and the on-premise data gateway refreshes with no issues. But as soon as I create a merged query using both sources, I cannot get it to refresh. I beleive my gateway data sources are set up properly since I can get them to work fine individually. I have done a lot of trial and error testing and just can't get it to work.