Forum Discussion
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
Hi, Anonymous
Enter the datasets settings in the power bi service, and edit the credentials under the data source credentials.
If the server is on-premises, you'll also need to configure the gateway and make sure it works.
error:
Click on Settings->Datasets and edit the credentials:
For reference:
https://carldesouza.com/using-direct-query-vs-import-with-power-bi/
https://stackoverflow.com/questions/58616839/powerbi-online-vs-desktop-credentials-for-sql-server
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi, Anonymous
Enter the datasets settings in the power bi service, and edit the credentials under the data source credentials.
If the server is on-premises, you'll also need to configure the gateway and make sure it works.
error:
Click on Settings->Datasets and edit the credentials:
For reference:
https://carldesouza.com/using-direct-query-vs-import-with-power-bi/
https://stackoverflow.com/questions/58616839/powerbi-online-vs-desktop-credentials-for-sql-server
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.