Forum Discussion
PowerBI Personal On-premise Gateway Connection Reverted to Cloud Connection and Unable to Restore
I never solved the initial problem with the Personal gateway, but was able to make it work after switching to an Enterprise gateway. After I had the Enterprise gateway, I could create a connection to MySQL in the PowerBi.com settings (which was not an option for some reason with the Personal gateway), enable access for cloud connections to use the gateway, and then I could map the cloud connections in all dashboards to the new enterprise gateway. This only worked for dashboards that were connected to the same schema on the MySQL database, but i went ahead and cleaned everything up to point to a single schema and utilize that one connection.
I have the same issue, I used to use Powerbi desktop and connect to mysql DB (import mode) then publish and use the personal mode gateway for a refresh,
Suddenly on 4th April 2024, I had to edit some things in the Powerbi desktop dashboard, then I published as usual and found that the Gateway connection reverted to the cloud connection which is giving me a credential error when I try to connect through the cloud connection,
I tried to publish another dashboard and I found the same issue happened,
I tried to reinstall DataGateway but still have the same issue