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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Is there a way to copy data from a datasource and then delete the datasource while keeping the copy?

Hello,

 

I need to load a data source (CSV file) from a Jenkins job. So far, so good. The content of the CSV file is never the same except from one column. The problem is that I need to keep the previous week's data in Power Query ( even the column with the values that doesn't change ).

 

( I don't know if I've well explained so here's a detail of what I want to do )

 

I load the file example.csv :

MrZimo0_0-1654875218826.png

 

The next week I want to load the same file but it's content has changed with :

MrZimo0_1-1654875382332.png

 

But I want to keep the content of the file from the precedent week, so my table would look like this : 

MrZimo0_2-1654875535794.png

 

Is there a way to do this in Power Query ?

1 REPLY 1
Anonymous
Not applicable

Hi, 

 

If I understand correctly, are you looking to essentially append the new CSV file to the old one? If so, you could import the new CSV file > Click on the old query > click on Append Queries > In the pop up window click the drop-down and select the new query > Disable Load from the new query by right clicking on the query. 

 

Hope this helps. 

 

Best

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.