Thanks for helping! I’ve been using a MySQL database as a data source without any major issues, so far. However, a couple of days ago I’ve noticed that one of the datasets isn’t refreshing properly. The dataset is published in PBI Service and it has been refreshing without any errors reported but the data hasn’t actually been updated in days.
I went back to the original pbix file, tried to refresh and got the following message for one of the tables
OLE DB or ODBC error: [DataSource.Error] MySQL: We cannot convert a value of type System.String to type System.Guid…
I read somewhere that I should try deleting all transformation steps which include data type changing. I did that but it didn’t make a difference.
Has anyone ever come across this issue or has a sense of what I should be looking at in order to try to resolve it?
I use the same datasource and same tables (transformed in a more or less similar way to begin with) for many of my reports and only this one has been reporting the error.
Any help is appreciated!