Data disappeared from my report. Error message: "One or two calculated tables need to be refreshed."

[Keshav5]

Hi all, I was working on a report in PowerBI desktop for a while and had data connected from Salesforce and Excel. I had created a lot of visuals and pages in this report and it was working absolutely fine for all this while. Today, I opened the report and all my data, models, and tables were gone. There is nothing to be found at all. I can only see a message displaying "One or two calculated tables need to be refreshed." but upon refreshing too, I cannot see anything. The report looks brand new even though the report name is still present.  I have added a screenshot below for reference. Does anyone has any solution to this? It would be very helpful, thank you

[Idrissshatila]

Hello @Keshav5 ,

I suggest you open a ticket with microsoft support for urgent and fast response since this looks like an issue or a bug 

open a ticket through this link https://support.powerbi.com

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡

[sergej_og]

Maybe right click on your .pbix and option restore prior version (or something similar).
But it is not alway available.
Or ask your admin about available versions of your .pbix

[Keshav5]

Hi @sergej_og , yeah it's quite scary. 
Well, how do I restore an earlier/prior version of the .pbix? I only had one file since the beginning on which I was 'saving as' after every change.

My sources were Salesforce Reports and Excel Workbook. They are still in place and intact. It is very weird how the data just vanished and I am just seeing the same message everytime I open the report- 'one or two calculated measures need to be refreshed.' But nothing happens after refreshing it.

Do you have any potential solution to it?

Thanks in advance

[sergej_og]

Crazy story about disappearing complete data.

Can try to restore an earliler/prior version of your .pbix?
And what about your sources. Are they still be in place?