Replace data in a table by deleting data and re-importing

[Anonymous]

I have data in a spreadsheet which I have successfully imported into PowerPivot (Office365 Excel). I have added some Calculated Columns to the resultant table.

What I want to do now is load a 'fresh' dataset into the table, replacing what is currently there. I guess I really want to delete the data from my table, but keep the empty table. Then import a fresh copy of the spreadsheet into the table and so not lose the calculated columns.

I cannot find an easy way to 

a) Delete all the data from the table, but not delete the table (an extreme thing to do I concede)

b) Then import data into an 'empty table'

Any guidance would be greatly appreciated. (I am a bit newbie to this having not used it for a few years). Thanks

[Anonymous]

Sounds like you just want to point your power query operation at a new dataset right? 

If you're using Excel, go to the Data tab, click Queries & Connections then double click on the query you'd like to change (on the righthand side). 

Now you should be in the power query editor. from, look at "Source" at the top of query settings. It'll likely say something like -> 

"= Excel.CurrentWorkbook(){[Name="Table1"]}[Content]" -> this means it's referencing data on THIS excel work book. so you just need to change that data and click refresh. 

If it says something like this -> 

= Excel.Workbook(File.Contents("C:\Users\YOURNAME\Desktop\Book3.xlsx"), null, true) -> then all you need to do is double click on "Source" and point it at the new dataset. 

[dax]

Hi @Anonymous , 

I am not clear  about your requirement, if you want to get current day's value, I think you could filter it by date, then import this in Excel. If possible, could you please inform me more detailed information(such as your expected output and your sample data )? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mariusz]

Hi @Anonymous 

Have used power query to add these columns? if so you should be ok to just replace the data in excel table and refreshing.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn