Forum Discussion

dthomas's avatar
dthomas
Frequent Visitor
9 years ago

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...
Gateways
dthomas's avatar
dthomas
Frequent Visitor
9 years ago

Thanks KFP, I'll try that if I go back to the standard gateway.

  • jason435's avatar
    jason435
    Icon for Helper II rankHelper II
    8 years ago

    I am having a similar problem to this.

     

    I have and ODBC database (PostgreSQL), and a couple tables in excel. The excel files are in onedrive. I would like to 'merge queries' a table from ODBC and an excel table. It works fine in PowerBI desktop. However, I can not get the gateway to work once I 'expand' the columns after the table merge.

     

    I can get the gateway to work if I delete the merge. I have datagateway enterprise. I could switch to personal for testing, but in the long term I would need to get enterprise working.