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])

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.