Forum Discussion
Program execution reached an invalid state
Hi all, I'm having this error when I try to refresh the data. Does anyone have any ideas to solve this issue? Any help would be much appreciated. Thanks in advance! Kindl...
Remove the part of your query that sets the specific fields as date or datetime (you can leave all other Change Type parameters in though) and see if that fixes it. Power BI might already be reading the field in as a date from your source data (i.e. SQL Database), so that extra step is unnecessary now. This fixed the problem for me. I removed it and could see that the field was already being read as date type.
This worked for me thanks!
