Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
11 | |
10 | |
7 | |
2 | |
2 |
User | Count |
---|---|
14 | |
10 | |
7 | |
2 | |
2 |