Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 :
The next week I want to load the same file but it's content has changed with :
But I want to keep the content of the file from the precedent week, so my table would look like this :
Is there a way to do this in Power Query ?
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
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
10 | |
8 | |
7 | |
6 | |
6 |