Forum Discussion
Unable to Edit Credentials in PBI Service - MySQL source
Hi @v-yilong-msft ,
This issue is resolved. To be fair, I did not try the service tags. I opened a support ticket and it was resolved in 2nd session after screen sharing.
Here are the steps we took:
Updated documentation from Microsoft shows that Personal Gateway no longer support MySQL https://learn.microsoft.com/en-us/power-query/connectors/mysql-database
Removed Personal Gateway
Install the Oracle MySQL Connector/NET
Install / Switch to use Standard mode of On-premises data gateway
We opened the report file in Power BI Desktop.
We cleared local connections and global permissions for the data sources.
We also cleared cache memory from files in options.
We tried to refresh the file in Power BI Desktop and published it to Power BI Service.
We then setup the gateway connection for MySQL and Web source.Thank you Microsoft and Community.
Hi Dave-ExpSC ,
I think you first need to make sure that MySQL and Power BI Service are accessible to each other, and secondly sometimes credentials can be about corrupt or expired. I think you can do it right according to the following documentation: Use service tags with Power BI - Power BI | Microsoft Learn
Since the status of the connection is shown as offline in "Manage Connections and Gateways" and the local data gateway (Personal Mode) is shown as online, there may be a mismatch or configuration issue. So I think you might want to consider deleting the connection in "Manage Connections and Gateways" and adding it again.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Thank you for responding and helping out. I started with deleting the connection in "Manage Connections and Gateways" since it was less complicated. I tried to add it back in but I still get an error message and now can not add it back.
- Unable to create connection for the following reason: Unable to connect to the data source. Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration and contact a data source administrator to troubleshoot this issue.
I presumed I could not add it back in because I needed to do the Service Tags per your suggestion. I went to Azure and it says I have to have an account. Do I have to get an account that I will be paying for in 12 months? I see Microsoft Entra - can I perform the fix there? Please advise so I can take the next step.
Curious to know why my Auto Refreshes have been working for 2 years but now I have to fix it by getting another account. Did requirements change? I SINCERELY appreciate your assistance!!
Hi Dave-ExpSC ,
Firstly as you can see from your error you need to make sure the data source is configured correctly and accessible.
Secondly using the Azure service now requires an Azure account and you can do what you need to do during its free trial.
As for auto-refresh, the requirements or configuration on the Azure side may have changed in a way that affects the settings.The Azure service is constantly updated and sometimes these updates may introduce changes that require adjustments to existing configurations. The credentials used by the auto-refresh feature may also have expired, or the service tag may need to be updated due to a change in the IP address used by the Azure service. To resolve auto-refresh issues, you may need to review the latest changes to Azure configuration requirements and update your settings accordingly.Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.