postgresql

4 Topics

PowerBI gateway / postgresql / npgsql error 400
Good day, please bear with me on this once, since I have no previous knowledge about PBI gateways but I was assigned to a project where I'm supposed to maintain one. Our Client asked us to install npgsql on our VM gateway, so he can connect to his supplier's database (postgresql). I simply installed it on main drive and thought that it should be done (please correct me if I'm wrong). Today he sent me a message that he received error 400. From provided screen I noticed that he is using basic authentication, so my thought is that supplier's DB required OAuth, not basic? But since it takes very long time for them to answer, I would like to be prepared. Is it more access / credentials issue or my installation was a mess?
Solved
Copycat
2 years ago Place Service
3.2KViews
0likes
1Comment
Scheduled Data Refresh Error on Postgres:The PostgreSQL source doesn't support encrypted connections
Hi all, This is my configuration: 1) Power Bi Desktop on my PC 2) Postgressql DB on company server 3) Published report on powerbi online I created some reports and published them on powerbi online. Everythings fine. I want to automatically schedule the data refresh but I have this error The PostgreSQL source doesn't support encrypted connections I'm trying different solution but nothing helped. Can someone help me to find a way to solve? Regards.
Solved
Anonymous
2 years ago Place Service
6.9KViews
0likes
3Comments
PostgreSQL- Publish Error
I'm having an issue around published dashboard that connect to PostgreSQL that do not work. From my Power BI desktop, I can connect to PostgreSQL and build a (direct query) viz with no issues. I can even publish and get the "success" window. However, when I go to view the published dashboard, I get an access error about credentials. I have not modified anything on the PostgreSQL/ AWS side, but I'm wondering if there is something outside of Power BI that needs to be modified (maybe ralated to SSL)? Thank you. Thank you in advanced
Solved
Anonymous
4 years ago Place Service
1KViews
0likes
1Comment
PostgreSQL Live Connection Without a Gateway
Hi Everyone, We have a PostgreSQL database on a Linux server. I can easily connect to it with the required credentials from PBI Desktop but naturally(?) not able to perform live connection. My client doesn't allow me to install a gateway on a virtual machine for some reasons. Dataset on the published report returns me this error message: "Your data source can't be refreshed because the credentials are invalid." As I know, there is no way to create a live connection and scheduled refreshes from an on-premises PostgreSQL db without a gateway. Do you have any alternative brilliant idea to get a solution on this case without using a gateway? ps-1: Our dataset is quite tiny so they can replace it from PostgreSQL to anywhere, even to Excel files. ps-2: I've tried both (ODBC drivers and PBI's direct PostgreSQL connection) Thanks a lot. Cuneyt
Solved
Anonymous
5 years ago Place Service
2.8KViews
0likes
2Comments