Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

chang_B

Calculated column works in Power BI desktop but not Power BI service. Visual won't load.

Submitted by Advocate I on ‎02-15-2023 05:46 AM

I have a pie chart visual in my report that uses a calculated column as one of the fields. Up until now it stopped working in Power BI service. Nothing has changed on the report and it has always worked in the past. The visual works fine in Power BI desktop but when published to Service it gives me an error. Any ideas why it would stop working suddenly?

 

chang_B_0-1676468657256.png

 

Status: Accepted

Hi @chang_B 

It’s a known issue . The engineers are actively working on this issue and I will come back with an update if there is any progress.

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
46 Comments (46 New)
Comments
blopez11
Resident Rockstar
Resident Rockstar
‎03-13-2023 05:19 PM

It is still not working for me.

blopez11
Resident Rockstar
Resident Rockstar
‎03-15-2023 05:29 PM

The issue now seems to be resolved for us.

Maieev
Resolver I
Resolver I
‎03-24-2023 04:05 AM

Issue resolved for me too :).

ChinChin
Regular Visitor
‎05-24-2023 10:20 PM

I am having the same issue where any visuals using calculated columns won't have data on after the dataset is refreshed in the Power BI service. I have updated my Power BI Desktop to the May 2023 version and the issue still remains. Replacing the calculated columns with calculated measures have fixed the issue but there is a couple of the calculated columns that cannot be replaced with calculated measures. Why is this becoming an issue since Feb 2023?

akbar-amini-219
Regular Visitor
‎02-05-2024 02:57 AM

I had a similar problem, when I filtered my report with a slicer, in powerBI it worked, but in shared report it didn't. 

Finally I changed my formula. I had "All" function and I changed it to "Allexcept"; and it worked. 

Anonymous
Not applicable
‎02-15-2024 08:45 AM

I use cumulative measures in several reports. They show correctly in visualization in PBI desktop, but  in the service they show incorrect results. It worked correctly before.  

As "ibendlin" informed me: " So yes, it is possible that there are differences in the rendering engine between desktop and service (we had very frequent service updates already this year). " 

Will that issue be addressed some time soon? 

Thank you! 

Idea Statuses