Forum Discussion
PowerBI refresh fail - Expression Error.
I'm also having this issue. It just hit me for the first time and there is nothing unsual in what I'm doing while refreshing my dataset.
Processing error: XML parsing failed at line 57, column 34: Illegal name character.
I checked all my tables and only one of them had 34 or more columns. When looking the column 34, line 57, there is no data, its null, as it always have been. So I have no ideia why this error is happening now.
Despite that, my dashboards are up to date. So the error message seems to be off, sending wrong signals.
Does anyone have a fix for that?
Thanks!
May have identified the issue here. I'll do some testing today and provide some feedback.
In my case it looks related to the fact that I have multiple queries that are based on the exact same table in the source database (just with different filters).
This seems like it could be the issue.
If that's the case, this is a new bug introduced over the last few days.
EDIT: thiagozaiden and anyone else who may be having this issue. It appears to be a bug introduced in the last few days.
It occurrs when you have more than one query that is based on the same table in your dataset.
I got around the issue but altering my queries so that I only had a single query for each table, and then used DAX outside of the Query Editor to do lookups to the apprpriate portions of the table.