Error code :"Couldn't load the data for this visual"

[anonymous1124]

I have this error code when I publish my power bi desktop report to the web workspace. 

Error code:" The query referenced column 'LocalDateTable_3dcabea0-fe0e-4c98-8b6e-01a7916b0f88'[Day] which depends on another column, relationship or measure that is not in a valid state. Additional information: ''

It shows the btm right graph on desktop version, but it could not load data on the web version.

Desktop Version:

Web Version:

Please share your thoughts, thank you

[anonymous1124]

Hi, which exact dependencies should I check on? There are a lot of columns

[AbhinavJoshi]

You should look at the LocalDateTable_3dcabea0-fe0e-4c98-8b6e-01a7916b0f88'[Day]  column, or the column of the visual which is not available in the visual.

[AbhinavJoshi]

Hello @anonymous1124 , as @jennratten suggestted, query dependencies can help a lot in Power Query. I'll also recomment ensuring a refresh preview in power query and a refresh in dekstop ensuring you get the data you are expecting. 

[jennratten]

I recommend checking the dependencies for the field used in the visual to locate the problem.  Sometimes things appear a little differently in desktop vs. online and there can be several reasons for this.  Tracing the dependencies should resolve the issue though.