Forum Discussion

trubeko's avatar
trubeko
Regular Visitor
6 years ago

"Cannot load model" error when using Data Gateway to access Azure Database for PostgreSQL

Hello,   I'm attempting to create a Power BI report based on the data we have in an Azure Database for PostgreSQL. I've created a report with success and published it to the Power BI service and de...
Need Help
v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi trubeko ,

 

If your dataset not only contains Azure Database for PostgreSQL but also the on premise data source, then note that you may need to select Allow user's cloud data sources to refresh through this gateway cluster option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.

 

 

Or try to upgrade the gateway to latest version.

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

trubeko's avatar
trubeko
Regular Visitor
6 years ago

Hello,

 

Thank you for these suggestions. I've activated this option, but the error is still reproduced. As of the Data Gateway version - I've just downloaded and installed it yesterday, so it is the most recent one as of now (Version 3000.8.452, AUgust 2019).

 

Thank you,

Timur

  • trubeko's avatar
    trubeko
    Regular Visitor
    6 years ago

    An update: I've tried to create a new report in Power BI Desktop using a "Power BI Dateset" as a source in the "Get Data" screen. It didn't work either, but Power BI Desktop showed more details about the error. The error message is: "DirectQuery may not be used with this data source".

     

    Does it mean that there is no way to confogure Data Gateway to use DirectQueries with "Azure database for PostgreSQL"? It works in PowerBI Desktop, why won't it work via Data Gateway?