"One or more calculated columns need to be manually refreshed." Getting error EVEN IN NEW REPORT

[RobertSparza]

Hello Community,

I have looked all over and haven't been able to find a solution for this, firstly i thought it was my report, but noticed when creating a new one got the exact same error when trying to add a new column to a table.

In this example created a report from scratch adding random data to show the problem, no info imported or so, just added a manual table. 

Hope someone have a solution for this or, Can we assume it could be a bug?

Thanks!
Roberto E.

[zahlenschubser]

I think I mananged to find what cause it at least in my case - I had a malfunctioning custom column that in turn triggered other custom columns to #ERROR. Once I fixed it, the yellow bar with the error message disappeared as well.

[ianallen13D]

Same - getting this error today as well.  If anyone has any fixes for it, please share.  

[ianallen13D]

Adding this info on here too ... 

Today I tried adding a calculated column to a practice file on one laptop running version 2.123.742.0 64-Bit and keep getting that #ERROR.  

I also just now, took the same file on another laptop which is running version 2.124.1052.0 64-Bit which I downloaded fresh last night and installed and it works fine on my personal laptop with no problems, so while it still may be something I'm doing or whatnot, but there is a possibility that it could be a bug issue?

[Colm]

I had the same issue!

In my case, I have all the DAX measures grouped in one table but I forgot to delete the original column that the table creates when you click on "Enter Data" to add this new DAX measures table.

So I just erased that column and the warning was gone.

[LEO_RAM]

This is really frustraiting, I'm having the same issue right after the Novemebr update and it looks like December update did not fix it. 

 @amitchandak   I follow your solutions and have applied many of them on my work, do you any imputs on this issue?

[Syndicate_Admin]

Hello community.

I get the same error when I want to add a new column.

In my case, I haven't been harmed by any report, but it's still frustrating because I'm stuck in the course because I'm just in a module where I have to add a new column and I haven't been able to do it since that error appeared.

Apparently it's because of the new update but do you know if it's going to be fixed?

[Turtelly]

That kept happening to me until I found that I had one calculated column that was empty and you have to get rid of that

[Turtelly]

I hate to say this but it took me some time before I was able to find one measured column that I never got to finish. It won't tell you which column, I went one by one before I could find it. You could either look at each calculated column if you completed your dax calculation or if you look at your table view and #error column. Then, that's the one!

[ianallen13D]

Were the unfinished columns in the same table or in another table?  The table I was using, I completed started from scratch, redid the query and still was getting the same thing.  I even tried other files that I had saved and every time I tried to add a column, it would give me the #ERROR. 

[zahlenschubser]

I'm having the same problem. I already checked all tables and columns for errors, refreshed the report, manually refreshed the previews, no success.

[PrinceMathew]

Hi, I am getting the same error when creating a new column "One or More calculated columns need to be manually refreshed."

Only started happening since the latest update. Version: 2.123.742.0 64-bit (November 2023)

I thought it was something to do with the datasource / table relationships / dax calculation and removed all and still it didnt fix the issue.

Also, imported a simple excel sheet and tried to add a column and it still showing the same error.

[crunchwa206]

I'm having this issue as well since updating to the latest version of PBI. It's breaking my existing reports and saying the calculated column in question "does not hold any data because it needs to be recalculated or refreshed."

[Ahmedx]

you need to enter data or formulas and everything will work

[RobertSparza]

I did, what I'm finding weird is that i get the error as soon as I click add New Column and was not getting this error in the past. On other reports it generate and error on other calculated columns.

Regards,

Roberto E.

[NaraYUN]

I'm not sure if it will be helpful, but in my customer case, I was able to resolve the error message using the following steps. 

1. Check in Power BI for any empty measures or empty columns, and delete them if found.
2. Click on "Transform Data" to switch to Power Query. Press the "Refresh Preview" button, then click on the "Close & Apply" button.
3. After Step2, click on "Refresh" in the still-visible error message(One or more calculated columns need to be manually refreshed.). then I found a new blank column in the data panel on the right. In my case, clicking on the column immediately deleted it. If it doesn't automatically delete, you may manually remove it. Afterward, the error message was resolved.

[JaviMacanudo]

That worked for me

[iRunOutdoors]

Hey, I started getting the same message as well. Frustrating as it's breaking my report. In one instance of creating my column, it said I had a circular dependency to another column, which was strange because I wasn't even using that column. It was a basic calculate(count(fieldname)). 

[kleigh]

CALCULATE in calc columns can create non-obvious circular dependecies, because of how the DAX engine works. See Avoiding circular dependency errors in DAX - SQLBI

[vicky_]

Hey, I just want to add that i'm also experiencing the same thing, so it's most likely a bug with the latest version. But it's not breaking any of my reports or calculations, so I have been pretty much ignoring it.