Power Bi Schedule Refresh

[User0201_1]

Hello Team,

I have created a dashboard using import mode with 5 private Google Sheets & ODBC. The data source is ODBC, and we used a replica of the large database. The dashboard is published on the service, but I’m facing two issues:

1. "Failed to test the connection to your data source. Please retry your credentials."
2. "Some credentials aren't validated as they are set to skip test connection."

All the credentials for gateways and cloud connections are updated, but the issues persist. Please see the attached images for reference.

I need help to resolve these issues. Your assistance would be greatly appreciated.

Thank you.

[v-zhengdxu-msft · Accepted solution]

Hi @User0201_1 

Issue 1:

Ensure that the ODBC data source is correctly configured in your system. This includes checking the DSN settings and ensuring that the correct drivers are installed.

Please refer to this document:

Power Query ODBC connector - Power Query | Microsoft Learn

If you're using an on-premises data gateway, ensure that it's correctly configured and running. The gateway needs to be online and accessible by Power BI to refresh the data.

On-premises data gateway - Power BI | Microsoft Learn

Issue 2:

Try re-entering the credentials for the data sources in Power BI Service. Go to the dataset settings, and under the Data source credentials, update the credentials again, ensuring that the option to skip the test connection is not s
Ensure that the credentials are correctly encrypted and stored. This might involve checking the gateway's configuration or how the credentials are managed in Power BI Service.elected.

Configure credentials programmatically for Power BI embedded analytics - Power BI | Microsoft Learn

Best Regards

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

[mohitkumawat]

Hi @User0201_1 ,

Some credentials aren't validated as they are set to skip test connection" which indicates credentials might be bypassing the test uncheck the box for "Skip Test Connection" (if available). also google docs

links not required gateway only file reuired so remove and try