Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply

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

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

Asmaaelsheikh_0-1722768654474.png

 

 

TIA

 

1 ACCEPTED SOLUTION
v-yohua-msft
Community Support
Community Support

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.

vyohuamsft_0-1722822346554.png

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

vyohuamsft_1-1722822412225.png

The error disappears

vyohuamsft_2-1722822573347.png

 

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.

View solution in original post

2 REPLIES 2
v-yohua-msft
Community Support
Community Support

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.

vyohuamsft_0-1722822346554.png

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

vyohuamsft_1-1722822412225.png

The error disappears

vyohuamsft_2-1722822573347.png

 

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.

Thanks @ v-yajiewan-msft

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Kudoed Authors