Forum Discussion

khoibui's avatar
khoibui
New Member
8 years ago
Solved

MySQL connector: value "preferred"is not the correct type

Hello,   I have an issue with using Power BI to connect to a MySQL instance (without SSL encryption)   Power BI: Version: 2.57.5068.721 64-bit (April, 2018) MySQL connector NET: 8.0.11   Error...
  • kpriemer's avatar
    kpriemer
    8 years ago

    I had the same issue. I downgraded the mysql connector to 6.10.6 and then it workeded.

kpriemer's avatar
kpriemer
New Member
8 years ago

I had the same issue. I downgraded the mysql connector to 6.10.6 and then it workeded.

  • mparso1's avatar
    mparso1
    New Member
    8 years ago

    This solution worked for me as well.

     

    Is there a reason why the latest version of the MySQL Connector/NET is causing this failure:

    Value 'Preferred' is not of the correct type

  • Armenni's avatar
    Armenni
    Frequent Visitor
    8 years ago

    Thank you! Downgrading also worked for me.

    • arun_1047's avatar
      arun_1047
      Icon for Helper I rankHelper I
      8 years ago

      Hello,

      I have installed the My SQL Connector 6.10.6 as mentioned in the message. I was able to connect to the server and created the dashboard. When i tried to schedule refresh in Power BI report Server getting the below error message.

       

       

      Power BI  Server Version : Version 1.2.6660.39920 (Build 15.0.2.389), March 2018

       

       

      "Status: Error Failed Data Refresh, Exception Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: '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. The exception was raised by the IDbCommand interface.
      The current operation was cancelled because another operation in the transaction failed.
      The command has been canceled.. The exception was raised by the IDbCommand interface.
      The command has been canceled.. The exception was raised by the IDbCommand interface.
      '.
         at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.ExecuteActionWithLogging(Action methodToExecute, String description, String localizedDescription, String messageInFailure, RefreshInfo refreshInfo, DataAccessors dataAccessors, ReportEventType operation, Boolean isDataRetrieval, Boolean showInExecutionLog, Boolean sendToTelemetry)
         at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.RefreshData(RefreshInfo refreshInfo)
         at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<>c__DisplayClass9.<ExecuteActionWithLogging>b__7()
         at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<ExecuteFuncWithLogging>d__3`1.MoveNext()"