Forum Discussion
"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...
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
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?