PowerBI Recognizes mySQL as Cloud-based

Hi raken ,

We have reported this issue and submitted it to the product team.

They have been aware of the issue and the engineers will do their best to resolve it. I will update here if there is any progress, so please be patient. 

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.

Updated from MSFT.

Users are no longer able to utilize personal gateways with MySql. If the user's MySql is inaccessible on the cloud, they will be required to transition to employing the Enterprise Gateway and establish connections through it. However, if the user's MySql server is accessible via the cloud, they can leverage the latest feature update to connect directly without the necessity of a Gateway.

Hello Community.
I received information that the Microsoft product team really made a change and as a side effect, MySQL data sources are no longer recognized by the Personal Gateway. It seems to me that the development team is already aware of this “but still does not have a date for solution”, and I believe they are also following this forum.
We need to gather the community now and reinforce the need to resume functionality as quickly as possible given the great impact it is causing with several users. I believe that this decision to change was not so assertive. Let’s reinforce this topic in order to bring to the development team or even the Microsoft product management the dissatisfaction with the problem, and what this generates in our working days.
Strength community.

I am also experiencing the same issue. Apparently, it started a few days ago. The data sources connected to MySQL are no longer recognized by the Personal Gateway, When I try to enter the username and password, I receive an error notification: "An error happened while reading data from the provider: ‘One or more errors occurred.’"
The MySQL data sources have all started to be considered as cloud-based, but this was not the case, in fact, it has never been like this. I also have several reports stopped and still without a solution.

Hi. I still have this problem. Has anyone discovered a solution?

Good day Fabric community support!

I'm facing the same issue whereby MySQL datasources are suddenly recognized as Cloud based.

All existing reports in the PBI Service, connected to the same host is still refreshing, however any newly publised reports failes with this error: "DataSource.MissingClientLibrary: We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'.. DataSourceKind = MySql. DataSourcePath......[my Database and Table names]", as it's meant to connect via the Gateway, however the option is greayed out as if it is a Cloud connection.

The same new report refreshes sucessfully in PBI Desktop.

Can someone please assist as soon as possible.

Regards

Fadiel

I'm referring to this option:

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:

1. Ensure that the local data gateway is properly configured and running.
2. 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.
3. 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.

Hi all,

Are you having problems using encrypted connections in conjunction with a MySQL data source? Are you intermittently unable to refresh the data?
Please try refreshing the data without an encrypted connection to see if it works.
If the problem persists, can you provide the full error message when the data refresh fails so that we can better understand and solve your problem.

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.

I have same problem. MYSQL connections to db is set to cloud based and credentials are not working. I have no problem using db in power bi desktop. I also uninstalled personal gateway to previous version from january 24, deleted report that is using this connection, deleted connection to MYsql in connections published report again but still the same. So now my reports are unusable . Any fix?

Glad it isn't just me going mad! I thought I'd caused a huge problem within our Power BI set up last night until I found your ticket as well and realised it was due to the personal gateway treating mySQL as a cloud source and not on-premise (and needing the gateway).

I'm flicking back all my connections to ODBC in the interim as they work still (a pain but it'll get you working again?)

Also found csv's that would normally refresh fine as a data source also can't, so that's fun!

All this because I was trying to get a new report to schedule, and I ended up toppling everything else that was working (and shouldn't have been)