cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sdeleener Frequent Visitor
Frequent Visitor

specific columns do not show data

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.2017-05-31_15-53-09.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

kind regards,

2 ACCEPTED SOLUTIONS

Accepted Solutions
v-yulgu-msft Super Contributor
Super Contributor

Re: specific columns do not show data

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.

1.PNG

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

sdeleener Frequent Visitor
Frequent Visitor

Re: specific columns do not show data

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

View solution in original post

3 REPLIES 3
v-yulgu-msft Super Contributor
Super Contributor

Re: specific columns do not show data

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.

1.PNG

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

sdeleener Frequent Visitor
Frequent Visitor

Re: specific columns do not show data

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

View solution in original post

v-yulgu-msft Super Contributor
Super Contributor

Re: specific columns do not show data

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Top Kudoed Authors
Users Online
Currently online: 364 members 3,421 guests
Please welcome our newest community members: