topic Re: Failed to test the connection to your data source. Please retry your credentials in Report Server

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

Asmaa-elsheikh — Sun, 04 Aug 2024 10:53:34 GMT

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

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

Anonymous — Mon, 05 Aug 2024 01:53:20 GMT

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.

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

Asmaa-elsheikh — Sun, 11 Aug 2024 09:34:21 GMT

Thanks @ v-yajiewan-msft

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