Forum Discussion

Link's avatar
Link
Frequent Visitor
6 years ago
Solved

PostgreSQL data source using encrypted connection when published?

Hi Team,   I'm publishing a report based off a PostgreSQL database that I'm hosting on an AWS EC2 instance, which I have specifically selected it not be a secure connection:     This works...
Need Help
  • Link's avatar
    Link
    6 years ago

    UPDATE:

     

    I went through the support gauntlet to try to get this resolved, and learned a couple of things that aren't listed anywhere in the documentation:

     

     - SSL needs to be enabled, PowerBI Service doesn't care about what settings you have selected in the creation of the report and there's no way to change that

    - The SSL certificate needs to be one signed by a registered CA, it can't be a self-signed certificate

     

    I didn't get as far as working out how to have the certificate maintained in PowerBI, however I have the inkling that if it's installed in Windows (to allow for report creation in PowerBI Desktop) then it will likely be included when publishing the report. Don't quote me on that, I haven't tested it.

     

    We've moved away from PostgreSQL onto an AzureSQL as a solution, luckily the server creation was for this product so we could pivot pretty easily.

     

    Hope this helps someone else.

Link's avatar
Link
Frequent Visitor
6 years ago

UPDATE:

 

I went through the support gauntlet to try to get this resolved, and learned a couple of things that aren't listed anywhere in the documentation:

 

 - SSL needs to be enabled, PowerBI Service doesn't care about what settings you have selected in the creation of the report and there's no way to change that

- The SSL certificate needs to be one signed by a registered CA, it can't be a self-signed certificate

 

I didn't get as far as working out how to have the certificate maintained in PowerBI, however I have the inkling that if it's installed in Windows (to allow for report creation in PowerBI Desktop) then it will likely be included when publishing the report. Don't quote me on that, I haven't tested it.

 

We've moved away from PostgreSQL onto an AzureSQL as a solution, luckily the server creation was for this product so we could pivot pretty easily.

 

Hope this helps someone else.

  • ipiestudio's avatar
    ipiestudio
    Regular Visitor
    5 years ago

    Linkwhere can one find registered CA? We are trying to use Power BI desktop + service with self signed certificate with openssl, but I can't find where can we create certificate with official CA?