Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Anonymous
Not applicable

Pro User needs to increment data from excel

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.

 

 

 

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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. 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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. 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn 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

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors