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

[Digger]

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

how to fix?

[Agucho76]

Hello @Digger I have the same problem.

Could you solve it?

Thanks! 

[Kletzy · Accepted solution]

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

[amitchandak]

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

[Digger]

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]

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]

@Kletzy  not solved yet

[Kletzy]

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.