Forum Discussion

Digger's avatar
Digger
Icon for Post Patron rankPost Patron
5 years ago
Solved

DataSource.Error: MySQL: We cannot convert a value of type System.String to type System.Guid.

DataSource.Error: MySQL: We cannot convert a value of type System.String to type System.Guid.

 

 

how to fix?

Need Help
Show and Tell
Tips and Tricks
  • Kletzy's avatar
    Kletzy
    4 years ago

    Digger this solved if for me = MySQL.Database("xxxxxxx", "xxxxxxx", [ReturnSingleDatabase=true, OldGuids=true])

8 Replies

  • Kletzy's avatar
    Kletzy
    Icon for Advocate III rankAdvocate III
    4 years ago

    Digger this solved if for me = MySQL.Database("xxxxxxx", "xxxxxxx", [ReturnSingleDatabase=true, OldGuids=true])

    • Michel_Soares's avatar
      Michel_Soares
      Frequent Visitor
      2 years ago

      Kletzy using OldGuids=true solved my problem, i have no more errors in my table.

      Thank you!

       

      Adding some information I have searched about what this means

      • OldGuids: A logical (true/false) that sets whether char(36) columns (if false) or binary(16) columns (if true) will be treated as GUIDs. The default value is false. Link Here 

       

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Digger , Open the power query, and check is there a type conversion. Remove that step and try.

    • Digger's avatar
      Digger
      Icon for Post Patron rankPost Patron
      5 years ago

      no conversion, error on source step, in adminer it work well no errors and uid showing, but in PBI error appears, it is possible to set "old guid=True" in PBI?

      • Kletzy's avatar
        Kletzy
        Icon for Advocate III rankAdvocate III
        4 years ago

        Were you able to resolve this? I am receiving exactly the same error message "DataSource.Error: MySQL: We cannot convert a value of type System.String to type System.Guid." and have no conversion steps - Source and Navigation only.