Home Power BI #PowerBI Auto Recovery

#PowerBI Auto Recovery

by Prathy Kamasani

A quick post, how many times in Power BI Desktop, have you clicked on “No, remove the files.” and then say OOPS! Well, I did plenty of times to discover this trick.

In short, you can find those removed files under Temp folder like many other windows application files. Usually, the location will be somewhere like this – C:UsersprathyAppDataLocalMicrosoftPowerBI DesktopTempSaves. This location depends upon which version of Power BI Desktop you have. Beware, these files will be removed whenever you clear your Temp Directory.

In long let’s see what happens with Power BI Desktop Auto Recovery and where we can find PBI related files. By default Power BI Desktop saves Auto recovery files; you can find Auto Recovery settings under Power BI Desktop options.

When a user creates or opens a Power BI Model, Power BI desktop saves a copy under Auto Recovery and Temp Saves. When the user closes without saving, Power BI Desktop will save an Auto Recovered Power BI file under the Auto Recovery file location given under Power BI Options. When you click on “No, remove files”, It will remove files from the Auto Recovery folder. But, files under Temp Saves are still there.

Remember, every time you open a recovered file or open a file from Temp Saves, Power BI Desktop will refresh all queries again. I think it’s for security purpose, not great when your queries take a long time to reload all the data but it’s better than losing all the hard work.

That’s all, Temp Saves; saved my life many times. Hope it helps someone out there too.

Stay Safe!

Prathy

 

 

You may also like

5 comments

Bruce 21 December 2022 - 4:10 am

Feel lucky to have found this today. Thank you!

Reply
Now You See Me 10 May 2021 - 7:50 am

I dont usually comment but anything. But, your article saved me today. Thanks alot. Cheers.

Reply
fp1967 7 March 2021 - 7:50 am

You save my life and file today 🙂

Reply
pranit 3 September 2020 - 8:29 am

superb tip.. It saved my day..

Reply
TJ Doherty 28 May 2020 - 5:58 pm

Did not know that, but a great tip (and find). Thanks Prathy!

Reply

Leave a Reply