Forum Discussion
The exception was raised by the IDbCommand interface
Hello
Need help.
I have a report in PBI Desktop that works correctly with the Gateway, VNET
connected and accessing my mysql server.
When the public lathe displays this error and does not update the data
Erro na origem de dados: [ValidateMarkupTags][ccon]DataSource.MissingClientLibrary:
We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'.. DataSourceKind = [ccon]MySql[/ccon]. DataSourcePath = [ccon]xx.x.x.4;MyDB[/ccon]. [/ccon];[ccon]We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'.[/ccon]. The exception was raised by the IDbCommand interface. Table: consen cad_endereco.
URI de Cluster: WABI-BRAZIL-SOUTH-redirect.analysis.windows.net
ID de atividade: feca76df-5542-497d-b3f7-fb72c4cde8e1
ID do Pedido: b9812de9-d89c-500e-cffc-cb7d9b219e07
Hora: 2024-04-15 17:08:45Z
Hi MiguelYogui ,
Based on the description of the error message.，This is typically due to the .NET Data Provider for MySQL not being installed or not registered correctly on the machine where the gateway is running.
You can try the following operation:
1.Ensure that the MySQL Connector/Net is installed on the gateway machine.
2.After installation, restart the gateway service and attempt the data refresh again.Here a similar issue was resolved where the user was using Regional Settings:
Solved: Everything works great on PBI Desktop, scheduled r... - Microsoft Fabric Community
This is the related document, you can view this content:
Solved: Power BI Desktop - Unable to Connect - Microsoft Fabric Community
Solved: Unable to connect with Mysql from app.powerbi - Microsoft Fabric Community
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi MiguelYogui ,
Based on the description of the error message.，This is typically due to the .NET Data Provider for MySQL not being installed or not registered correctly on the machine where the gateway is running.
You can try the following operation:
1.Ensure that the MySQL Connector/Net is installed on the gateway machine.
2.After installation, restart the gateway service and attempt the data refresh again.Here a similar issue was resolved where the user was using Regional Settings:
Solved: Everything works great on PBI Desktop, scheduled r... - Microsoft Fabric Community
This is the related document, you can view this content:
Solved: Power BI Desktop - Unable to Connect - Microsoft Fabric Community
Solved: Unable to connect with Mysql from app.powerbi - Microsoft Fabric Community
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.