cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mdawesdigitalk Frequent Visitor
Frequent Visitor

Re: PowerBI refresh fail - Expression Error.

Same error with us as follows;

An error occurred while processing the data in the dataset.

XML parsing failed at line 83, column 40: Semicolon expected.

Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net

Time: 2016-07-01 10:05:32Z

 

This is a dataset that has been refreshing 2 or 3 times a day for 6 months without fail, until yesterday.

 

If I take the original desktop file and refresh I get no errors.  Reupload that refreshed file onto Service via OneDrive and the data refreshes, but the dataset will not refresh within Service.

 

Any pointers appreciated, but suspect it is a Microsoft introduced bug somewhere.....

 

dstramilov Regular Visitor
Regular Visitor

Re: 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
Mattnade Frequent Visitor
Frequent Visitor

Re: PowerBI refresh fail - Expression Error.

I think the same is happening to me - 

 

Processing errorXML parsing failed at line 157, column 39: Illegal qualified name character.
.
Cluster URIWABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net
Activity ID63e7096d-018a-ab56-44b5-f5c31d16c857
Request IDf72a9ee2-9e08-2dc1-da2f-cde6d9c9a5c6
Time2016-07-04 00:36:54Z

 

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....

 

ianbarker Regular Visitor
Regular Visitor

Re: PowerBI refresh fail - Expression Error.

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.

Moderator v-qiuyu-msft
Moderator

Re: PowerBI refresh fail - Expression Error.

Hi @ianbarker,

 

From the error message, we can see that the issue is caused by dataset data. Please check if there is any changes in Dynamic CRM Online. Also you can create a new dataset to get data from Dynamic CRM Online in Power BI Desktop to see if the same dataset can be processed.

 

Best Regards,

Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ianbarker Regular Visitor
Regular Visitor

Re: PowerBI refresh fail - Expression Error.

Hi @v-qiuyu-msft

 

I can assure you that there had been no changes to the dataset data.

The CRM Online instance I was pointing to at the time was a staging database, so there had not even been any transactions posted in it.

All I can tell you is that one day the dataset refreshed and the next it didn't and was giving the errors previously mentioned.

 

I have resolved my issue now, via the workaround in my earlier post. However, this is obviously causing issues for a number of other people.

 

Thanks,

Ian

thiagozaiden Frequent Visitor
Frequent Visitor

Re: PowerBI refresh fail - Expression Error.

Hello everyone!

 

Its working normally for me again. I didn't do anything actually, and my dataset has some queries depending on the same table.

I believe they already found a solution.

 

Thanks!

Mattnade Frequent Visitor
Frequent Visitor

Re: PowerBI refresh fail - Expression Error.

Same here - working normally without any changes from me.

 

Must have been related to their status message....

NickEtch Frequent Visitor
Frequent Visitor

Re: PowerBI refresh fail - Expression Error.

Yesterday the refresh started to work for us again. However, this morning, we received the same error so I am not sure that this issue has been resolved. Has there been any other possible solutions to resolving this issue?

 

Something went wrong.
 
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Processing errorXML parsing failed at line 47, column 32: Semicolon expected.
.
Cluster URIDF-MSIT-SCUS-redirect.analysis.windows.net
Activity IDffbf782e-c2ec-4645-a6d4-3d7eb7d9bb83
Request ID92b05d42-90eb-d615-fe9b-fb64e741d894
Time2016-07-07 16:37:40Z
dstramilov Regular Visitor
Regular Visitor

Re: PowerBI refresh fail - Expression Error.

Start working for me too), will see how it goes.

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 62 members 1,274 guests
Please welcome our newest community members: