Visuals can't be loaded because of column not in a valid state?

[Anonymous]

Hi, 

In powerbi Dektop its working fine however in the service when you do schedule refresh it shows the following error. I have to manually refresh it to show the visual.

[jramon]

Hello,

I am facing the same problem, is it solved somewhere?

[Jrubio93]

Has this issue been resolved?, i am also facing the same problem.

[v-zhangti]

Hi, @Anonymous 

What is the format of the Query 1 column field? Is it that the desktop can understand this value, but not on the service, the problem comes. You can refer to the link: https://community.powerbi.com/t5/Service/The-query-referenced-column-which-depends-on-another-column/m-p/166866#M23134 

Also check to see if Query 1 is a direct query to another PBI dataset, but does not grant the user build access.

FYI:

https://community.powerbi.com/t5/Service/Couldn-t-load-the-data-for-this-visual/m-p/1970776 

https://community.powerbi.com/t5/Service/Couldn-t-load-the-data-for-this-visual/m-p/2255737 

https://community.powerbi.com/t5/Service/Updating-visuals-fails-in-Power-BI-Service-but-it-s-OK-with/m-p/2166526#M143643 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

This seems to be a widespread issue at the moment. If you have a Pro license you can consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/