Forum Discussion
PowerBI Recognizes mySQL as Cloud-based
Hi raken ,
Based on the information you provided. First, understand that Power BI handles data sources differently depending on where they are hosted. Entering the Power BI service, the way data sources are managed may change, especially if Power BI interprets the data source location differently. For detailed information, see this document:
Data sources for the Power BI service - Power BI | Microsoft Learn
You can try the following steps first to troubleshoot and resolve the issue:
- Ensure that the local data gateway is properly configured and running.
- In the Power BI service, check the data source settings for the dataset. Ensure that it is correctly pointing to the use of the local data gateway and is not being treated as a cloud data source.
- Verify the authentication method used for the MySQL data source in Power BI Desktop and Power BI Services. Differences in authentication methods can cause problems.
If the error persists after trying the above steps, can you provide more information that would be helpful in resolving your issue:
- Whether the problem occurs intermittently or continuously.
- Were there any changes made to the network configuration or Power BI service when the issue started?
- Can you share more detailed information about the error message received during the authentication failure.
More details can also help us to troubleshoot whether this is a known issue or not.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dear Ada Wang,
Thank you for your valuable suggestions. I've checked the configurations as recommended but still face the same issue. To provide more context:
- Other data sources like Oracle and local folders are connecting normally through the gateway.
- Reports from other authors that access the same MySQL server are not treated as cloud-based, which suggests that this issue is specific to my reports.
- To my knowledge, there hasn't been any recent changes to our network configuration or service updates that could have caused this. The only change was updates and modifications made to the report content in Power BI Desktop before republishing.
Is it possible that the local data gateway settings could change spontaneously? Or could the republishing of updated reports from Power BI Desktop somehow alter how Power BI service interprets the data source location?
Your further guidance on this matter would be greatly appreciated.
Best regards,
raken
Yes, even I am facing the same issue. All of a sudden, Personal gateway is not working for Mysql and it shows only cloud connection to set up but it works well in Power BI desktop client. All scheduled reports are failing and it is a major issue on day-today basis as we have to manually run all these reports.
Not sure, if there is any recent upgarde to Personal gateway that is causing the issue..
Kindly post the solution if you find one..
Thanks in advance
SriKrty
I am experiencing the same issue. My MySQL data connections are suddenly recognized as cloud based (even if they are not) and I am not able to connect to them from PBI services.
