Forum Discussion

hibarrbm's avatar
hibarrbm
Icon for Helper I rankHelper I
5 years ago

If i delete data from Excel data source also delete data already imported into my tables

I have created a transactional data table in Power BI from an Excel data source file. As the weeks go on, i will need to import new data every week into my Power BI table and keep historicals. However, i do not want my Excel source file to continue to grow as it will reach excel limits very soon. 

 

If i delete old data from the Excel source file to make room for the new data, will that also delete the data already imported into my power bi table?

data protection
Need Help
Tips and Tricks

3 Replies

  • Angith_Nair's avatar
    Angith_Nair
    Icon for Continued Contributor rankContinued Contributor
    5 years ago

    Hi hibarrbm ,

    The answer to your question is YES. Because whenever you will import new data into excel, you also need to refresh your Power BI file. Now when old data is removed from the excel source and when you refresh the Power BI file then from Power BI also the old data will be removed. Ultimately Power BI is using an Excel file as a source.

    If this helps, kindly mark it as a solution. Appreciate with Kuddos.

    • hibarrbm's avatar
      hibarrbm
      Icon for Helper I rankHelper I
      5 years ago

      Thanks for sharing!

      Any suggestions on how to import new data without having to create a new connection to essentially a new excel file every week moving forward?

      • v-easonf-msft's avatar
        v-easonf-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi, hibarrbm 

        As of now,Power BI is unable to achieve this feature. Power BI is better at data modeling and report creation than  data storage.

        You need to consider more from the datasource, such as how to back up the differential data.

         

        Best Regards,
        Community Support Team _ Eason