Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi There,
I am having couple of excel files and I have imported them into Power BI as two different tables. Out of these two files, first file is having one month of data and second file has data for a period of last six month. I have appeneded these two tables and created as a new table.
Now, I want to make sure that going forward the first file alone need to be uploaded again in power bi and this get simply added to the overall data i.e. to last seven months of data, that means, any new data that gets added it has the record of all previous data (kind of cumulating the data).
Is this possible in Power BI? Can it be done in edit queries page itself?
Regards,
PKR
If I am understanding you correctly, it sounds like you want a Folder query where you do a Combine Binaries. This type of query automatically appends all the data from all the files in a folder so you can keep dropping additional files in there and it all gets appended together.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
5 | |
4 | |
3 | |
2 |
User | Count |
---|---|
12 | |
9 | |
7 | |
2 | |
2 |