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
- v-haibl-msft
Microsoft Employee
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
- Vicky_Song
Impactful Individual
Status changed:NewtoDone