Forum Discussion

ianbarker's avatar
ianbarker
Helper III
10 years ago

PowerBI refresh fail - Expression Error.

Has anyone seen this issue when refreshing dataset in app.powerbi.com? Seems to work ok in Desktop.   This is based on a Desktop file I have uploaded which is looking at data from Dynamics CRM.  ...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
10 years ago

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

ianbarker's avatar
ianbarker
Helper III
10 years ago

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