Forum Discussion
DirectQuery error: DirectQuery may not be used with this data source. PostgreSQL
I have a report, exclusively made up of visualizations from a PostgreSQL database on DirectQuery mode. It works just fine in Dektop. I published it to Service and configured an enterprise gateway. When I visit the report page, none of the visualizations work, all throwing this error:
DirectQuery error: DirectQuery may not be used with this data source - please consider moving to a supported data source or upgrading the SQL Server data source to the latest available version. Please try again later or contact support. If you contact support, please provide these details. Activity ID25c0d669-ba89-46f4-bc07-ebf4e5bc3b70 Request ID1304ac04-2bb2-c7d1-eb19-c52168c9505b Correlation IDb2a81c79-9993-99eb-4553-c96088575240 TimeWed Sep 11 2019 18:05:33 GMT+0200 (Central European Summer Time) Version13.0.10668.164 Cluster URIhttps://wabi-west-europe-d-primary-redirect.analysis.windows.net
The solution in my case:
I went through this Microsoft's support team, and after a few days, it was apparent that DirectQuery for PostgreSQL was released as a feature for Power BI Desktop, but the on-premises Data Gateway was not supporting it.
Last week around Sep 20, the new version of the Data Gateway was released and fixed the issue.
5 Replies
The solution in my case:
I went through this Microsoft's support team, and after a few days, it was apparent that DirectQuery for PostgreSQL was released as a feature for Power BI Desktop, but the on-premises Data Gateway was not supporting it.
Last week around Sep 20, the new version of the Data Gateway was released and fixed the issue.
HI nima_mlk ,
Any advanced query operation in your query editor? (e.g. merge, combine , reference other query, invoke custom function)
If this is a case, power bi gateway datasources may not map correctly with these advanced operations query tables.
Regards,
Xiaoxin Sheng
Hi Anonymous , thanks for your reply.
Not really. I have to tables coming from the same PostgreSQL data source in my Query Editor, and the only steps are "Source", and "Navigation", which is choosing the respective table from the database.
Also the aggregations on the visualizations are extremely simple. Only a count per category.
Regards,
Nima
Hi nima_mlk ,
Maybe you can take a look at following links about use custom data connector to achieve odbc directquery:
Enabling direct query for a data source via an odbc driver
Use custom data connectors with the on-premises data gateway
Regards,
Xiaoxin Sheng
