cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jpd99
Frequent Visitor

Direct Query Errors usign PostgreSQL

I have been trying in vain for days to create a direct query report drawing from a postgresql database now that this is supposedly supported.  Upon closing and re-opening an otherwise functioning report I get an error message: 'Couldn't load the data for this visual' across all visuals.

 

'Direct query may not be used with this data source - consider moving to a supported data source or upgrading the SQL server data source to the latest available version.'

 

I can't understand the failure since on saving the report worked ok.  It's extremely lim

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

@jpd99 ,

 

Currently, power bi doesn't support direct query/live connection with PostgreSQL data source. Please refer to doc below:

https://docs.microsoft.com/en-us/power-bi/power-bi-data-sources

 

Regards,

Jimmy Tao

View solution in original post

2 REPLIES 2
ikris
New Member

I encountered the same issue and I found a work around.

 

I installed a gateway and configured it to point to that postgres instance server, this acted sort of like a help for the data source to find a route and authenticate without encryption. However i observed that the direct query could now connect and if I changed data and refreshed on the dashboard, i would see the changes.

ikris_1-1603545947809.png

 

The only draw back was the gateway needs to be up, but the direct query works just fine

 

would love to hear from someone how many rules I have broken or any better option.

 

v-yuta-msft
Community Support
Community Support

@jpd99 ,

 

Currently, power bi doesn't support direct query/live connection with PostgreSQL data source. Please refer to doc below:

https://docs.microsoft.com/en-us/power-bi/power-bi-data-sources

 

Regards,

Jimmy Tao

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.