Forum Discussion

hibarrbm's avatar
hibarrbm
Helper 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. Howeve...
Data Protection
Need Help
Tips and Tricks
hibarrbm's avatar
hibarrbm
Helper 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
Community 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