cannot query internal supporting structures error

[ceelliott]

Hello, all. I'm using the web app of Power BI (data is in a OneDrive for Business/Sharepoint Excel doc), and everything has been working smoothly, when all the sudden I'm getting this error:

"Couldn't load data for the visual. 

Cannot query internal supporting structures for the column 'Satisfaction S18'[Coach's name:] becuase they are not processed. Please refresh or recalculate the table 'Satisfaction S18'."

Technical Details:

Activity ID: 3dcbf39b-3ccb-4e98-93c4-737d6f7d34fd

Request ID: 7f8a1657-727f-d238-e10a-79da6450c5b3

Correlation ID: cd59ab97-7bb1-be19-9f12-f60e7e7f8df9

Time: Tue Feb 06 2018 10:22:01 GMT-0500 (Eastern Standard Time)

Version: 13.0.4164.188

Cluster URI: https://wabi-us-east2-redirect.analysis.windows.net

I'm confused because the column in question is a list of names; there's nothing to "recalculate." I'm not sure what's going on, but any help would be wonderful: 

Solutions I've already tried: 

1. Adding more data and triggering a refresh

2. Copying/pasting all data into a new excel document with the same file name (trying to "clear out" weird formatting)

Thank you!

[ceelliott]

Hello, all. I'm using the web app of Power BI (data is in a OneDrive for Business/Sharepoint Excel doc), and everything has been working smoothly, when all the sudden I'm getting this error:

"Couldn't load data for the visual. 

Cannot query internal supporting structures for the column 'Satisfaction S18'[Coach's name:] becuase they are not processed. Please refresh or recalculate the table 'Satisfaction S18'."

Technical Details:

Activity ID: 3dcbf39b-3ccb-4e98-93c4-737d6f7d34fd

Request ID: 7f8a1657-727f-d238-e10a-79da6450c5b3

Correlation ID: cd59ab97-7bb1-be19-9f12-f60e7e7f8df9

Time: Tue Feb 06 2018 10:22:01 GMT-0500 (Eastern Standard Time)

Version: 13.0.4164.188

Cluster URI: https://wabi-us-east2-redirect.analysis.windows.net

I'm confused because the column in question is a list of names; there's nothing to "recalculate." I'm not sure what's going on, but any help would be wonderful: 

Solutions I've already tried: 

1. Adding more data and triggering a refresh

2. Copying/pasting all data into a new excel document with the same file name (trying to "clear out" weird formatting)

Thank you!

[v-huizhn-msft]

Hi @ceelliott,

For your scenario, have you done any special operation in in a OneDrive for Business/Sharepoint Excel doc? It's really weird because everything works smoothly at first, while it returns error suddenly. I personally suggest you create a support ticket on the right-bottom of this page to get dedicated support.

Best Regards,
Angelia