cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

PBI Desktop/Service: How to connect to DB Postgresql 9.6+ on linux (ubuntu server)

Greetings to all

I'm new to the power bi world. I have a point-in-time problem with the connectors to the DB. Since power bi desktop I manage to connect to my postgresql base on linux, I have done it with the PBID connector and with odbc. The problem is when I export the model to PBI Service in the MS cloud, the connection does not work. I've read several posts from here and elsewhere, but they're not clear in the solutions. In the end they recommend using a gateway on a windows virtual machine, and from there connect to postgresql. I think there must be some direct way to connect the postgresql running in linux to power bi services.

has anyone done it yet?

thank you in advance for your help

from Ecuador

Jose Orlando

1 ACCEPTED SOLUTION

The way I did it was with the gateway connected to a virtual machine with odbc installed. I don't know any other way.



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

1 REPLY 1

The way I did it was with the gateway connected to a virtual machine with odbc installed. I don't know any other way.



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors