We have a report that is using multiple data sources. One source is MSSQL 2014 sitting on a vm in azure which has the Power BI Gateway installed on it and is working fine. Our second data source is MYSQL as a service in azure. We are looking to set this report up on a refresh schedule but are getting the following error. I am able to connect to all data sources and refresh the report from my desktop. Once we try and publish it we are getting the following error.
Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details
| Activity ID: | 98d4b3a3-0072-443f-aa0b-bdd7fa1d95c4 |
| Request ID: | 74d35165-d774-201e-637b-a10ada10217e |
| Cluster URI: | https://wabi-west-us-redirect.analysis.windows.net/ |
| Status code: | 400 |
| Error Code: | DMTS_PublishDatasourceToClusterErrorCode |
| Time: | Tue Aug 18 2020 13:52:30 GMT-0700 (Pacific Daylight Time) |
| Service version: | 13.0.14114.59 |
| Client version: | 2008.2.02376-train | V12Reports: | Unable to connect to the data source undefined. | | Underlying error code: | -2147467259 | | Underlying error message: | MySQL: We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'. This error could've been the result of provider-specific client software being required, but missing on this computer. To download client software for this provider, visit the following site and choose the 64-bit (x64) version of, at minimum, 'MySQL Connector/Net': https://go.microsoft.com/fwlink/?LinkId=278885 | | DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 | | Microsoft.Data.Mashup.ValueError.ClientLibraryName: | MySQL Connector/Net | | Microsoft.Data.Mashup.ValueError.DataSourceKind: | MySql | | Microsoft.Data.Mashup.ValueError.DataSourcePath: | xxx-customapp-xxxxx.mysql.database.azure.com;selection_prod | | Microsoft.Data.Mashup.ValueError.download link: | https://go.microsoft.com/fwlink/?LinkId=278885 | | Microsoft.Data.Mashup.ValueError.Reason: | DataSource.MissingClientLibrary How do we refresh an MYSQL dataset that lives on SAAS? You cannot install the gateway. Is there a different kind of data connector needed. Thanks for your assistance in advance. |
|
