Forum Discussion

Murhadiyanto's avatar
Murhadiyanto
Frequent Visitor
6 years ago

Failed to update data source credentials for postgreSQL server in PowerBI Service

The full error message is :Failed to update data source credentials: An error happened while reading data from the provider: 'A connection attempt failed because the connected party did not properly ...
Need Help
Murhadiyanto's avatar
Murhadiyanto
Frequent Visitor
6 years ago

Hi, I'am Trying to Whitelist PowerBI service IP Address list into my alibaba cloud.

The datasource credentials already working .

But when i open mw dashboard , it's say like this

'Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.

Please try again later or contact support. If you contact support, please provide these details. 

 

Regards,

Murhadiyanto's avatar
Murhadiyanto
Frequent Visitor
6 years ago

v-lid-msft 

 

This is a screen shoot for the issue.

  • Murhadiyanto's avatar
    Murhadiyanto
    Frequent Visitor
    6 years ago

    v-lid-msft 

     

    Hello , any solution for me?

     

    Regards,

     

    Murhadiyanto

    • v-lid-msft's avatar
      v-lid-msft
      Community Support
      6 years ago

      Hi Murhadiyanto ,

       

      Does the dataset use DirectQuery Mode to connect the PostgreSQL? Have you configured SSL encryption for your PostgreSQL instance? If SSL encription is not configured properly in your data source, you can go to File->Options and Settings -> Data Source Settings in Power BI Desktop, select your PostgreSQL source and unclick "Encrypt connections", then published it to the service. Please test it with a copy of this report.


      Best regards,

       

      • Murhadiyanto's avatar
        Murhadiyanto
        Frequent Visitor
        6 years ago

        Hi , v-lid-msft 

         

        Yes the Dataset use direct query to Postgresql , But I doesn't configure the SSL.

         

        I'm already trying your solution but it's still got the error in my powerbi service

         

        Regards,

        Murhadiyanto