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
NickEtch's avatar
NickEtch
Microsoft Employee
10 years ago

I have also started to receive this error when trying to refresh my datasource. However, I only have two sql queries in my desktop file, each pulling from different tables. Refresh of the data in the desktop file does not provide any errors and I only receive the error after it is published to Power BI. Is there an alternate solution to this beyond trying to take the details out of Power BI to an external DAX solution?

 

In recreating the file from scratch, it does not appear to be causing the issue. However, doing a save as or copy of the file seems to replicate the issue. Possibly something became corrupt within the desktop file?

 

**Update** After posting the new file for processing, it appears that it too has started to get the error. So recreating the dataset and original file does not fix the issue.

NickEtch's avatar
NickEtch
Microsoft Employee
10 years ago

In recreating the file from scratch, it does not appear to be causing the issue. However, doing a save as or copy of the file seems to replicate the issue. Possibly something became corrupt within the desktop file?

 

**Update** After posting the new file for processing, it appears that it too has started to get the error. So recreating the dataset and original file does not fix the issue.

  • ianbarker's avatar
    ianbarker
    Helper III
    10 years ago

    NickEtch Perhaps you were getting a different issue? I didn't create mine from scratch. I just removed my duplicate tables and it resolved itself. Definitely some change on the Microsoft side.