Forum Discussion

Digger's avatar
Digger
Post Patron
4 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])

amitchandak's avatar
amitchandak
Super User
4 years ago

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

Digger's avatar
Digger
Post Patron
4 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
    Advocate 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.

    • Digger's avatar
      Digger
      Post Patron
      4 years ago

      Kletzy  not solved yet

      • Kletzy's avatar
        Kletzy
        Advocate III
        4 years ago

        Thanks Digger - seems strange that we are the only two having this issue - I cant find it anywhere else on Google. I do recall fixing something similar in the past but can't find or remember how I did it.