Forum Discussion
Failed 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
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.
Hi,
I don't really feel like that is an acceptable solution - if Microsoft were planning to stop allowing MySQL connections through a personal gateway, this needs to be communicated out properly. Which tells me this is a bug which needs fixing.
And further guidance is needed on utilising an enterprise gateway (a solution I did try but hit a brick wall with).
Hi, MainlineData
First, you need to download the Enterprise Gateway, which you can download by clicking on the link below:
Power BI Gateway | Microsoft Power BI
Select the standard mode version to download. After that, you'll need to configure the connection for your semantic model in Power BI Service, filling in the corresponding credentials:
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,
As I said - and appreciate it isn't your fault by any stretch - if Microsoft have removed MySQL databases from being used in a personal gateway, this needs to be communicated out as many other users are affected.
Until then, this feels like it is a bug Microsofts side which needs fixing.
If there has been some communication about it not being usable with a personal gateway, then I've not seen it at present.
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.