Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.