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

DirectQuery for PostgreSQL? Gateways on Linux?

 

My infrastructure is built on Linux and PostgreSQL, but my company is transitioning to Power BI. I was able to install PBI Desktop and connect to a PostgreSQL database on a Windows machine with a Personal Gateway and it works. I want to confirm:

  • I am not able to install a Gateway on a Linux OS, correct?
  • There is no option to do a DirectQuery or Live Connection to a PostgreSQL source?
  • There is no Enterprise Gateway (only Personal) for PostgreSQL

There is a subset of reports which need to be refreshed every 15-30 minutes. which is beyond the limit of 8 scheduled refreshes per day. Since a DirectQuery does not seem to work with PostgreSQL, my potential solution is to purchase an Azure Windows Server with SQL Server 2016 instance. I would then funnel my data (using BCP?) from my PostgreSQL to the Azure instance. Any experts out there who can comment on whether this would be a decent option? For reports which only need to be refreshed daily, I can retain the data in PostgreSQL and use the gateway to run some scheduled refreshes. 

1 ACCEPTED SOLUTION
v-yuezhe-msft
Microsoft
Microsoft

Hi @ldacey,

Firstly, as per this article, gateway installation requires 64-bit version of Windows 7 / Windows Server 2008 R2 (or later).

Secondly, yes, there is no option to do a DirectQuery or Live Connection to a PostgreSQL source and connecting to PostgreSQL is not supported yet with the Enterprise Gateway currently.

Thirdly, in order to utilize DirectQuery feature, you would need to transfer data from PostgreSQL to other database management system such as SQL Server or Azure SQL Server. You can check the following similar thread and blogs about how to move data from PostgreSQL to as SQL Server or Azure SQL Server.

Best tool to migrate a PostgreSQL database to MS SQL 2005
Export data from Postgres to SQL Server using SSIS
PostgreSQL to SQL Azure Migration and Sync

 


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
scott_goley
Frequent Visitor

@ldacey 

 

This is something that I'm actively working on since my business ran into a situation that made working around this an impossibility. Including the usage of an enterprise gateway to facilitate real time availability all the time.

Read more about my progress so far here:

https://justreadrtheinstructions.com/post/2019-06-15-directquery-postgres-howto/

v-yuezhe-msft
Microsoft
Microsoft

Hi @ldacey,

Firstly, as per this article, gateway installation requires 64-bit version of Windows 7 / Windows Server 2008 R2 (or later).

Secondly, yes, there is no option to do a DirectQuery or Live Connection to a PostgreSQL source and connecting to PostgreSQL is not supported yet with the Enterprise Gateway currently.

Thirdly, in order to utilize DirectQuery feature, you would need to transfer data from PostgreSQL to other database management system such as SQL Server or Azure SQL Server. You can check the following similar thread and blogs about how to move data from PostgreSQL to as SQL Server or Azure SQL Server.

Best tool to migrate a PostgreSQL database to MS SQL 2005
Export data from Postgres to SQL Server using SSIS
PostgreSQL to SQL Azure Migration and Sync

 


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

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