oscara's avatar
oscara
Frequent Visitor
9 years ago
Status:
Done

Couldn't load the data for this visual - The query referenced column ... is not in a valid state

Hi,

 

We are experiencing issues when refreshing a dataset through the data gateway. In Power BI Desktop the visuals are working fine, and the same when publishing them to the Power BI service. But after a scheduled or user-triggered refresh we get this error message in the report in the online service:

This error message is reoccuring for many visuals and referenced columns/measures. If I republish the desktop file, it works again until it is refreshed from the gateway. The refresh history looks good, no error messages.

 

I have changed the formats of the referenced columns, and testing a little bit, but it doesn't seem to help. The columns are not  of date/time type, most of them are currency formatted.

 

Any ideas?

 

 

 

 

2 Comments