Failed to test the connection to your data source. Please retry your credentials

[Asmaa-elsheikh]

Hi All,

How I could resolve this error

My data is connect to local excel sheet & another google sheet & I found this error disabled my auto-refresh 

I tried to edit the google sheet credential, but the error exists

TIA

[Anonymous · Accepted solution]

Hi, @Asmaa-elsheikh 

According to my observations, your web is not reporting errors, which means that there is no problem with your Google file, and the problem may be on local excel. I just tested and after uploading a Power BI file imported from excel, it had the same error as you in data source validation.

Click Edit credentials, then set the level of privacy you want for your data source, and click Sign in

The error disappears

You can learn more from the following link:

Troubleshoot gateways - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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

[Asmaa-elsheikh]

Thanks @ v-yajiewan-msft

This was the issue & it has been solved following the steps you have mentioned