Hello,
I have been using Microsoft POWER BI for a while to analyze data taken directly from a MySQL DB. In order to get data from MySQL it is necessary to download and install a connector:
https://dev.mysql.com/downloads/connector/net/
I had several reports up and running. They were refreshing automatically from POWER BI Service using a personal mode gateway.
After some problems trying to configure a new report I uninstalled and intalled the conector among other things. Right now I can't connect at all to MySQL from POWER BI, as even the desktop version says it did not find the necessary connector.
In this link
https://learn.microsoft.com/en-us/power-query/connectors/mysql-database it is mentioned to do the following operation to check if the connector is correctly installed.:
"The MySQL connector requires the MySQL Connector/NET package to be correctly installed. To determine if the package has installed correctly, open a PowerShell window and run the following command:
[System.Data.Common.DbProviderFactories]::GetFactoryClasses()|ogv"
Which gives me the following error:
"Exception when calling "GetFactoryClasses" with arguments "0": "An error occurred while creating the configuration section handler for system.data: The column 'InvariantName' is restricted to be unique. The value 'is already present Mysql.Data.MySqlClient'. (C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config line 157)"
En línea: 1 Carácter: 1
+ [System.Data.Common.DbProviderFactories]::GetFactoryClasses()|ogv
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : ConfigurationErrorsException"
Any help solving this?