Forum Discussion

Tabaqat_Team's avatar
Tabaqat_Team
Frequent Visitor
3 years ago
Solved

PostgreSQL incremental refresh failing

I have set up a connection to a PostgreSQL database and made an incremental refresh 8 times and it fails every time and returns this message: The PostgreSQL source doesn't support encrypted connectio...
  • v-yueyunzh-msft's avatar
    3 years ago

    Hi , Tabaqat_Team

    Based on your error situation and screenshots given, I think the root cause of the issue is that the PostgreSQL source does not support encrypted connections, and Power BI is attempting to establish an encrypted connection despite being set to "Not encrypted."

     

    If convenient, would you like to also go to the Power BI desktop source .pbix file to edit the datasource connection to the "PostgreSQL source" is not encrypted and publish the report to the Power BI service again to configure the datasource connection again.

    For the detailed process in the Power BI desktop, you may also refer to this official document link:

    Power Query PostgreSQL connector - Power Query | Microsoft Learn

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly