Forum Discussion

draj's avatar
draj
Frequent Visitor
6 years ago
Solved

Connecting Postgres on AWS from PowerBI Web

Hi all!   I recently created a report on PowerBI desktop while connected to a Postgres DB on AWS RDS. I managed to get around the credentials requirement using npgsql.   However, now I have publi...
Need Help
  • draj's avatar
    draj
    6 years ago

    So it turns out that there is a communication aspect between AWS and PowerBI. Recently AWS had a requirement for new certificate requirements, which cause this issue.

     

    The way I resolved it was to have an always-on laptop >> Install the Gateway there >> Run the usual set-up

     

    Now I can publish a dashboard from any other laptop, and the refresh will occur as usual

draj's avatar
draj
Frequent Visitor
6 years ago

So it turns out that there is a communication aspect between AWS and PowerBI. Recently AWS had a requirement for new certificate requirements, which cause this issue.

 

The way I resolved it was to have an always-on laptop >> Install the Gateway there >> Run the usual set-up

 

Now I can publish a dashboard from any other laptop, and the refresh will occur as usual

wshapiro's avatar
wshapiro
Frequent Visitor
5 years ago

drajI was able to connect PowerBI to Postgres hosted by RDS on Desktop, but when I view it in the web/cloud verison it gives me the error: "Failed to update data source credentials: An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure."

 

How did you get the connection to work on PowerBI web?