Data source credentials showing Failed to test the connection

[Vinit]

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.

[v-xiaoyan-msft]

Hi @Vinit ,

You can remove the failing data sources in data source setting.

We have had users with similar experiences to yours in the past, you can refer to this post below to see how they solved it.

Solved: Failed to test the connection to your data source.... - Microsoft Power BI Community

Best Regards,
Community Support Team _ Caitlyn

[Vinit]

Hi @v-xiaoyan-msft 

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,