This expression refers to 'efec9e6d-b8a5-477a-b2dd-5b5cd907eeff', which has an error.

[amadeusning]

My report was working perfectly when I refreshed it last time. However today when I try to refresh it again the following columns are in #ERROR. The raw data in these tables looks just like normal. However in the summary table, which I used to summary by week number with some adjustment, all columns relate to these two tables are not working. 

The error message I got is: This expression refers to 'efec9e6d-b8a5-477a-b2dd-5b5cd907eeff', which has an error.

 One of the fomulas I used is: 

Survey Score (RPS) (Current) = CALCULATE(AVERAGE('Raw Data - ServiceNow Survey'[sur_u_score]),'Staff Name List'[New Group]="RPS",FILTER('Week Number','Week Number'[Week Number]=Summary[Week Number]))

Those fomulas used to work perfectly and I did not make any changes since last time.

[v-chuncz-msft]

@amadeusning,

You may try to obtain some information from DMV in DAX Studio.

[amadeusning]

For that two tables, the data is extracted from csv files saved in a folder in our organisation's shared drive. I didn't add any new data to it since last update but it just not working anymore...