Forum Discussion

Vinit's avatar
Vinit
Frequent Visitor
3 years ago

Data source credentials showing Failed to test the connection

Hello all,

I get data source credentials showing Failed to test the connection, 

The report is generated in Directquery Mode from power bi desktop. Get data from postgresql, put server link, database name, sql query and table is generate. from that, report is create. after publishing into power bi service. Data source credentials showing Failed to test the connection having same login id, server, database name, user name and Password.

 

How to fix this error.

 

Let me know any furthur detail required,

Thanks.

 

Need Help

2 Replies

    • Vinit's avatar
      Vinit
      Frequent Visitor
      3 years ago

      Hi Anonymous 

      I applied your suggestion and the link that you share. These are mostly 3 types,

      1) Remove the failing data sources in the data source setting

      2) Edit permission - Edit Credential then close and apply

      3) Clear all permission from data source setting and recreate with new credentials.

      Right now, I only have one data source connection and which works fine (not failing) in power bi desktop. I also made a report. as I publish it into service. I got this message of connection error. also I put same credentials as of power bi desktop. I also did above 3 steps, Edit permission and check, it didn't work and then Clear all permission, recreate with new credentials but it shows same message I send in question. and I am using Postgresql databse connection 

      Please Let me know any details required,

      and If you have ay alternative solution please do share.

      Thanks,