Forum Discussion

nima_mlk's avatar
nima_mlk
Frequent Visitor
7 years ago
Solved

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. Wh...
Need Help
  • nima_mlk's avatar
    nima_mlk
    7 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

  • nima_mlk's avatar
    nima_mlk
    Frequent Visitor
    7 years ago

    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