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

[oscara]

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?

[v-haibl-msft]

@oscara

I saw such issue before but the column was date/time type, which was different from your scenario. I suggest you to create a support ticket at http://support.powerbi.com (see bottom of page).

Best Regards,

Herbert