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: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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:
47 Comments (47 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! 

Tempest_87
New Member
‎05-07-2024 06:56 PM

I had the exact same sounding problem. The below worked for me. Link here: https://community.fabric.microsoft.com/t5/Issues/Error-in-calculated-column-only-in-power-bi-service...

 

Credit to user magicbiman:

"I had the same issue, but I've worked out what was causing it in my case. One of my data sources, which the calculated column was referencing, didn't have it's privacy level appropriately defined in keeping with the other sources of data. This didn't prevent the desktop version from working, but when published to Power BI  service it was preventing the data from being retrieved.

 

You can check this from the Home bar -> data source settings -> select your referenced data source -> edit permissions. In my case the privacy level for the referenced data source hadn't been defined. Defining it appropriately resolved the issue."

Idea Statuses