Greg Scott on 07 Jan 2016 01:29:58
Any chance of connecting to PostgreSQL data Source with the new Enterprise Gateway, we can with the Personal Gateway, but really need the Enterprise Gateway
Administrator on 05 May 2017 05:39:03
Hello, I'm excited to mark this feature as "completed". PostgreSQL support was added to the On-premises data gateway in the latest release. Make sure to update your gateway and try it out! Thanks, Dimah The Power BI Gateway team
- Comments (19)
RE: PostgreSql Datasource for Enterprise Gateway
The request was for a datasource in the neterprise gateway for Postgresql. However you have marked it complete as it has been added to the on-premises gateway. Can you confirm if the datasource can be used on the enterprise gateway?
RE: PostgreSql Datasource for Enterprise Gateway
Dear Dimah:
I have been following your forum on the topic "PostgreSql Datasource for Enterprise Gateway" and I have certain doubts that I could not solve, I would like to have a clarification on this point since I am new using Power BI.
I have a PostgreSql Database which I want to connect with Power BI to show my reports with recent data, I understand that to do this I require a Gateway that allows me to make this connection.
My question is that the Gateway that allows me to connect Power BI is everything I need or require to buy from a third party some component to make this connection.
If that's right, where can I get those connectors?
Thanks for your answer.
regards,
RE: PostgreSql Datasource for Enterprise Gateway
'@Daniele, sorry to hear your disappointed, let's work on fixing it!
We looked into the error you sent and it looks like you were trying to refresh from the personal gateway and not the enterprise gateway, is that correct? Can you verify it thru the latest enterprise gateway please? This is the link to install the latest: https://go.microsoft.com/fwlink/?LinkId=820925&clcid=0x409
Also, regarding the refresh failure in the PBI Desktop can you send a frown please? That will be super helpful to further look at your issue.
RE: PostgreSql Datasource for Enterprise Gateway
'@Daniele, did you update to the latest gateway? What are you seeing in the logs? Send me an email to dimazaid.at.microsoft.com with the details
RE: PostgreSql Datasource for Enterprise Gateway
Great stuff! Gonna try it immediately. Thanks Dimah.
RE: PostgreSql Datasource for Enterprise Gateway
Doesn't work. It will allow you to add a PostgreSQL data source but then it will fail to update, no matter the number of attempts.
In the desktop app i will have to click refresh at least 4 or 5 times before a proper refresh, sometimes need to close and reopen the file.
Very disappointed.
Last refresh failed: Fri May 05 2017 10:19:37 GMT+0200 (W. Europe Daylight Time)
Hide details
Data source type: PostgreSQL
Data source error: PostgreSQL: Exception while reading from stream
Cluster URI: WABI-EUROPE-NORTH-B-redirect.analysis.windows.net
Activity ID: e7b3f817-efe7-d893-9cf7-28d4d7e70d7c
Request ID: 9addc751-1a62-193d-94b7-417b5862f388
Time: 2017-05-05 08:19:37Z
RE: PostgreSql Datasource for Enterprise Gateway
Like a lot of 3rd level education institutes we use PostgreSQL for our Moodle site (learning management system) and we'd love to see support for it in the Enterprise Gateway.
RE: PostgreSql Datasource for Enterprise Gateway
Personal gateway keeps also throwing errors at me. Opening a support ticket i was told to use MySQL until they will fix it....
I hope this will be sorted out soon. PostgreSQL is used quite a lot.
RE: PostgreSql Datasource for Enterprise Gateway
I need this!!!!!
RE: PostgreSql Datasource for Enterprise Gateway
How long is the review process? When can we expect an answer or solution?