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.
I have exel table A and table B.
Each day table B updates with new data.
Steps I want to take:
Day 1
Append B to A
A + B becomes a new data set C
Day 2
Append updated B to new data set C
Long Description
I recieve auto generated .csv reports daily from an application.
The application limits the .csv download size
So to overcome the download size I can only download one days worth of data.
Each day I want to combine the downloads and grow the data set.
In effect i want the combined downloads to become historical data that grows over time.
It sounds like I need the incremental feature of PowerBI Premium however I just have a Pro License.
Solved! Go to Solution.
I'm thinking you could just use the Import from folder feature. Then just drop the new csv file in that folder and refresh. Let Power Query do the heavy lifting of mashing it into one table.
I'm thinking you could just use the Import from folder feature. Then just drop the new csv file in that folder and refresh. Let Power Query do the heavy lifting of mashing it into one table.
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 |
---|---|
99 | |
50 | |
19 | |
12 | |
11 |