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.

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

     

    What is your gateways status? Does your postgres db allow connection from External IP ? It could be firewall blocking your Power BI service IP address. 

     

    If you have found a way do it please do post the solution,  since being a new feature it would be useful to have this figureout. 

     

    thanks