Forum Discussion
Helper IFailed to Test Connection to your Data Source - Retry Credentials - Only On Certain Reports
Hi, MainlineData
Thank you very much for your reply. This is documented in the official documentation:
Power Query MySQL database connector - Power Query | Microsoft Learn
As mentioned earlier, you can connect to MySQL using a standard gateway (Enterprise Gateway) or connect to your MySQL using a cloud link.
In addition, you can also refer to the following article to connect to your MySQL using dataflow:
Where to get data - Power Query | Microsoft Learn
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, MainlineData
In this case, there is an issue with your data source credentials, and you can try creating a new connection in Power BI Service. This connection will connect to your data source, and then configure the current new connection for the newly reported semantic model, instead of updating the credentials.
Also, whether other old reports that you use the current data source will be able to refresh? It's just that your new report has the current refresh error?
You can refer to the following cases with similar questions:
Solved: Failed to test the connection to your data source.... - Microsoft Fabric Community
Solved: Failed to test the connection to your data source.... - Microsoft Fabric Community
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MainlineDataHi,
When I've dug into this further, my core issue is linked to other behaviour that other users have found - that Power BI is treating a mySQL connection as a cloud source when it isn't (and isn't then using on-premise gateway).
See this ticket for best description - https://community.fabric.microsoft.com/t5/Service/PowerBI-Recognizes-mySQL-as-Cloud-based/m-p/3843180
I've just knocked the tower over by trying to investigate why this one report wouldn't work, and now knocked them all over.
- MainlineData
I had also checked my credentials multiple times, and tried recreating connections, and even deleting / reuploading.
Hi, MainlineData
Thanks for your reply. Here's how to fix it: If you can't access the MySQL server in the cloud, you need to switch to using Enterprise Gateway and set up a connection through Enterprise Gateway.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.