Forum Discussion
Unable to Edit Credentials in PBI Service - MySQL source
- 2 years ago
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 @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.