specific columns do not show data

[sdeleener]

Hi,

I had this issue before, and it got solved automatically after some random updates of the report.... now it is back and i can't find the reason again.

In my PowerBI desktop report the data in the B Costs & A Costs column show correctly.

When i upload the report to PowerBI online it also appears correctly

However, after the first scheduled automatic refresh these two columns doesn't show the data anymore.

Does anyone see a reason why this happens. these 2 fields are measures. the normal value of this column doesn't have this issue.

kind regards,

[v-yulgu-msft · Accepted solution]

Hi @sdeleener,

In my test, I could not reproduce your issue. The measure still worked fine after refreshing data.

I found a similar scenario as yours, you can take a look at as a reference: A group Measures stop calculating after a refresh

Besides, you could create a support at this page: https://powerbi.microsoft.com/en-us/support/ to get further advice.

Best regards,
Yuliana Gu

[v-yulgu-msft · Accepted solution]

Hi @sdeleener,

In my test, I could not reproduce your issue. The measure still worked fine after refreshing data.

I found a similar scenario as yours, you can take a look at as a reference: A group Measures stop calculating after a refresh

Besides, you could create a support at this page: https://powerbi.microsoft.com/en-us/support/ to get further advice.

Best regards,
Yuliana Gu

[sdeleener · Accepted solution]

That put me into the right direction. it must be linked to the value type of the data. 

In my measure i used a boolean value to filter, and this boolean was set as text in stead of boolean.

after this update, and the update of my measure (leaving the " ") it is fixed.

thanks for the hint

[v-yulgu-msft]

Hi @sdeleener,

Glad to hear that you have resolved your problem. Please kindly mark the corresponding reply as an answer so that some other community members having similiar concern can benefit from it. 

Regards,
Yuliana Gu