Forum Discussion
PowerBI Recognizes mySQL as Cloud-based
Until recently, I was able to access MySQL data via a personal on-premises data gateway without any issues. However, a few days ago, it suddenly started being recognized as cloud-based, l...
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: