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
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi dthomas,

 

Can you refresh the merged query successfully in Power BI Desktop? Also please check the Privacy Level Settings both in desktop and data sources under on-premise data gateway.

 

Best Regards,
Qiuyun Yu

dthomas's avatar
dthomas
Frequent Visitor
9 years ago

Yes, merged query does work great in Power BI Desktop.  I'll look into the privacy level settings.

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    Hi dthomas,

     

    How about the results after checking Privacy Level settings?

     

    Best Regards,
    Qiuyun Yu

    • dthomas's avatar
      dthomas
      Frequent Visitor
      9 years ago

      It didn't, but I changed to a personal gateway and that works.  So, I've been happy with it working on the personal gateway and haven't tried yet going back.