Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Anonymous
Not applicable

One or more calculated objects need to be manually refreshed?

I built a model in the desktop, published to the service and created an App. Have made a number of amendments inside the desktop and re-published multiple times and all was working fine. Yesterday I went back to the desktop to make further amendments and the report title was there but all data was gone (Report, Data & Model) and I was greeted with an error message stating "One or more calculated objects need to be manually refreshed" and there was a "Refresh now" button. Hitting Refresh didn't seem to do anything and data still not visible in the desktop. The Report and App in the Service are still there and functioning. How do I get back my data to make further amendments in the desktop? All ideas welcome. thanks

17 REPLIES 17
nixonba2
Frequent Visitor

This happened to me when I downloaded a .pbix from the service with a live link to the dataset. Data model appeared empty and this error was shown. I fixed it by going Get data > Power BI semantic models, then choosing the model it should have been linked to.

 

It's curious because I've downloaded numerous reports from the service and never had this problem before.

Syndicate_Admin
Administrator
Administrator

Help!! I have the same problem. Could anyone find a solution? 😅 My entire dataset completely disappeared. I don't see the way to recover

CarrieG13
New Member

I'm having the same issue and I am not seeing any answer. The data is just gone and if I reconnect it to the data source I don't have any of my columns or measures with my foirmulas. Help!

PowerBiJoshua
New Member

I am experiencing the same problem. Column is unable to be manually refreshed. If I publish this dataset, it will refresh forever and block the scheduled refresh from the next day.

I am not able to remove the column for some reason as well.

Norya
Frequent Visitor

no data transformation, same issue happened for me. here is the screenshot. i can not keep going my work! thank you!

 

isssue for_one or more calculated columns need to manually refreshed.jpg

Norya
Frequent Visitor

yes, i got the same issue and there is no date transformation, i do not know. could you please give a solution, i can not keep going my work.

MarjorieHG
Frequent Visitor

I got the same banner but once I corrected a column that returned #ERROR, it went away. It seems I started to write a code on a column the day before but forgot to finish it/delete it. After I finished it, the banner went away. My datasets didn't dissapear though.

bharatkumar2716
New Member

Hi, got the same message, and it has nothing in it now... in case of anyone in community aware to such error and how to overcome out please do advise us to get the things back to normal.

 

Anonymous
Not applicable

I am now experiencing this issue as well.

I even tried to replicate the build in a new PBI instance and the problem ocurred again.

Looking forward to getting a solution for this.

Keshav5
Regular Visitor

Hi @Anonymous , did you find my solution to this issue? I am facing the same problem right now. All my data and models have disappeared suddenly and I can just see the above error code "One or more calculated objects need to be manually refreshed"
If you know any step or advice that worked for you then please share across. Thanks 🙂

Syndicate_Admin
Administrator
Administrator

The same thing is happening to me. Is there a solution? In PowerQuery/Transform Data there is no table or data to update, so the commented solution does not work.

Thank you.

MarnieB
Frequent Visitor

I have experienced this same thing - has anyone posted a solution?? Thank you 

 

amitchandak
Super User
Super User

@Anonymous , Open Power Query and refresh all the tables one by one, and check for any errors.

 

Also on the data/Report view open all tables and check for any error field and try to correct that.

 

Refresh the table one by one in the data view and check for any errors and correct those.

 

 

As someone else reported this issue in the last few days, please check any issues reported https://community.powerbi.com/t5/Issues/idb-p/Issues

 

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
Anonymous
Not applicable

thanks @amitchandak - problem is I can't see the tables so am unable to refresh them - the tables aren't there 

@Anonymous , Have you checked it in Power query/Transform Data?

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Same as Simotab - There are no tables in the Transform Data - All of the data has just dissappeared.    I was switching between two enrviorments - I wonder if that has anything to do with it? 

 

Anonymous
Not applicable

@amitchandak yes I checked PQ / Transform Data - there are no Queries in there - no data at all?

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.