Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Post Prodigy
Post Prodigy

Is there a way to copy the current table to a backup table before importing new data from the web

Hi I am trying to find a way to look for changes in a text file I import from the web on a weekly basis. [every monday] the data is

I was hoping that if scheduled the the refresh every monday , it would copy the current data to the table called previous and import the current data to the table called current. 

I then need to find a way to compare each table to identify any changes.

Is this possible in PowerBI

Or would I be wasting my time , trying to get this to work.

Any help on this would be very much appreciated.


Community Support
Community Support

Hi @Pandadev ,


You can use dataflow to save historical data: 

Note: Incremental refresh of entities in Power BI dataflow is allowed for Premium and pro users.


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

Post Prodigy
Post Prodigy

@Pandadev One approach could be to first create an empty table with exactly the same structure (but an additional Date_Imported column at the end. Call it the archived table. 


Then, import the web CSV and add a Power Query step to add a column with Imported date. 

Something like:

= Table.AddColumn(#"Changed Type", "Date_Imported", each DateTime.LocalNow())


Then you can do an append of this newly imported table to the archived table. Thus on each refresh, the archive table will contain all old rows and the newly imported rows. 


The comparision logic will be on the archived table - you compare the rows from previous date with those from the current date.


I realize this is hardly a solution, but just throwing some ideas if they are of help. Good luck! 


Hi thanks for your idea. I have not used a power query before , so am struggling to work out how to put this in place.

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.