Forum Discussion
PowerBI refresh fail - Expression Error.
Same for me(((
| Processing error: | XML parsing failed at line 97, column 32: Semicolon expected. . |
| Cluster URI: | WABI-WEST-US-redirect.analysis.windows.net |
| Activity ID: | 700326bc-35e1-4323-b411-1a6f526faa12 |
| Request ID: | ce4a9089-64db-4305-b3c5-ff8e6d6e32ff |
| Time: | 2016-07-01 00:30:03Z |
I think the same is happening to me -
.
Anyone know if this is one and the same issue that is causing the "Users may experience processing errors when refreshing datasets in the Power BI service. We are working to resolve this issue as quickly as possible." status message we're being shown... or if I should be hunting for an issue with my dataset specifically?
Refreshes fine in Desktop, so I'm a little lost....
- ianbarker10 years agoHelper III
In my case, as per my edit, it was (or so I thought) related to the fact that I had multiple queries pointing to the same table in my data source. Combining those queries into a single query resolved my issue.
I was having a think about it and also wonder if the issue could be related to a naming convention with the queries.
In my case, originally, the multiple queries that pointed to the same table were all named very similarly. i.e. they all started with the word "Optionset". I wonder if anyone else here, even if you are not pointing more than 1 query to the same table, is naming more than a single query with a matching word?
Just a thought.