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.