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

Is it possible to keep data even if the source file is deleted?

I have a number of .CSV files I reference and am wondering if it is possible to configure Power BI so it imports those .CSV files and doesn't delete the data when I delete the source file. I'd like it all to be stored in the data model and only refresh if the source file changes in some way but not if it is permanently deleted.

1 ACCEPTED SOLUTION

Hi pbiuser2,

 

If you are connecting to a folder, which has been loaded into power bi is the absolute path of files in the folder, not the file itself. So once file has been removed, you should delete the path of that file in advanced editor.

 

In addtion, if you want to save file in power bi, you can import that file directly and then save your report as a PBIX file which means you can see the content of the file in power bi next time even the file has been removed.

 

Hope this is helpful.

 

Jimmy Tao

View solution in original post

9 REPLIES 9
Anonymous
Not applicable

The proper way to do this is, once the file has been loaded, go back in Power Query, right click on the Request and uncheck soemthing like "Include in the update of the report" :

include.png

Anonymous
Not applicable

@v-yuta-msft

 

If I delete a .CSV file in a folder that is being referenced in Power BI, I am seeing that said data disappears in my Power BI data model once it refreshes. Is there any way to force Power BI to store the data within the file itself without removing it once the original source is deleted from the folder?

 

Basically, I want to disassociate my data from the source to ensure I don't lose history if I accidentally delete a file.

Hi pbiuser2,

 

If you are connecting to a folder, which has been loaded into power bi is the absolute path of files in the folder, not the file itself. So once file has been removed, you should delete the path of that file in advanced editor.

 

In addtion, if you want to save file in power bi, you can import that file directly and then save your report as a PBIX file which means you can see the content of the file in power bi next time even the file has been removed.

 

Hope this is helpful.

 

Jimmy Tao

In case I do not delete the entire file but some of the records it contains, how do I preserve the deleted records?

renecernitz_0-1654776193716.png

 

v-yuta-msft
Community Support
Community Support

Hi pbiuser2,

 

Because you are using import mode so all of the data have been loaded in your data model, you only need to save the PBIX file.

 

Regards,

Jimmy Tao

Anonymous
Not applicable

Does that mean that, if the original is deleted, then the data will remain in PBI? I want to remove the errors in the Query Editor once this happens. Is it possible to stop it from showing an error?

Hi pbiuser2,

 

Which error are you encountering with? Could you please give some screenshots about your error?

 

Regards,

Jimmy Tao

Anonymous
Not applicable

@v-yuta-msft,

 

It is just the error in the Query Editor that says it can't locate the file. I was just wondering if there is a way to forcibly load the data into the data model and disassociate it form any source so no errors show.Error in BI.png

 

Hi pbiuser2,

 

According to the screenshot you posted, you are connecting the a folder which contains some files, this error occurs after the foler has been removed or name changed, right?

 

Please click Advanced Editor to modify your folder path\folder name like this:

1.PNG 

 

Regards,

Jimmy Tao

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.