Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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 i...
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    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

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi pbiuser2,

 

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

 

Regards,

Jimmy Tao

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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.

 

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    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:

     

     

    Regards,

    Jimmy Tao