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
AShadow
New Member
‎02-28-2023 05:58 AM

We are in the same boat, and are unable to change storage modes. We need this bug fixed. 

chang_B
Advocate I
Advocate I
‎02-28-2023 06:47 AM

@v-yetao1-msft  Can we please get an update on this? Many users are experiencing the same issue which I believe something changed in Power BI.

RLundahl
New Member
‎03-06-2023 07:53 AM

I don't understand why we have to Vote on bugs the MS team has introduced.  Things were working, they changed something, and now its broke.  This needs to be fixed, not voted on.

blopez11
Resident Rockstar
Resident Rockstar
‎03-06-2023 03:37 PM

Geez, I've been fighting this for the past few days, thought I was going crazy.  Decided to check the issues page and find it is not just me.  I am getting the same type error as original poster.  I am using a composite model as well, including Direct Query to Power BI dataset.  I have a calculated column in one of the tables in the shared dataset.  My report/dataset also resides in a premium capacity workspace.

 

It seems that this is impacting enough users that this should be addressed asap.

TSHECKEL
Advocate II
Advocate II
‎03-07-2023 06:04 AM

I had submitted a request through our Power BI subscription support team and I received the following notification this morning. 

 

This is a follow-up message. The product team has developed a fix for the issue reported. This fix is going to be released to all our PBI Tenants this week. I highly recommend testing any time later than 3/10/2023.  Please keep me updated if your issue is resolved or if you require additional assistance.

 

 

chang_B
Advocate I
Advocate I
‎03-07-2023 06:17 AM

@TSHECKEL Thanks for the update! Looking forward to the fix.

v-yetao1-msft
Community Support
Community Support
‎03-07-2023 06:00 PM
Status changed to: 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

CDC_JBA
New Member
‎03-13-2023 06:11 AM

Hi All,

FYI, we have been facing the same issue and we have just tested a workaround with the UTCNOW() function and it seems to have solved the issue... at least it works for the following calculated column (in Direct Query mode on a SSAS / Power dataset) :

Day Offset = //'Calendar'[Date]-TODAY() (--> previous formula)
DATEDIFF('Calendar'[Date], UTCNOW(), DAY)

Hope this helps 🙂
 
Jean-Baptiste ARZOUNIAN
 
Maieev
Resolver I
Resolver I
‎03-13-2023 06:40 AM

Hi @CDC_JBA ,

 

Unfortunately nothing changes in my case.

TSHECKEL
Advocate II
Advocate II
‎03-13-2023 09:14 AM

We've confirmed that this has now been resolved on our service(s).

Idea Statuses