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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. 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

16 REPLIES 16
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.

 

NJP58
New Member

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
New Member

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

 

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?

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors