Forum Discussion

mb0307's avatar
mb0307
Icon for Responsive Resident rankResponsive Resident
6 years ago

Add weekly data

Hi,   Please download 3 sample excels file from here: FILE DOWNLOAD    Week1 file is the main file and I want to merge (not aggregate) all the records from other weeks (week2 and 3) into Week1. ...
Need Help
mb0307's avatar
mb0307
Icon for Responsive Resident rankResponsive Resident
6 years ago

v-alq-msft   Thanks for your response.  Sorry this is not what I am after.

 

Please download 3 sample excels file from here:

FILE DOWNLOAD 

 

Week1 file is the main file and I want to merge (not aggregate) all the records from other weeks (week2 and 3) into Week1.

 

As you can imagine data will get bigger by each week so I just want incremental refresh for new file without updating existing data every time.

 

Can you provide instructions in steps as you did in your reply please? 

 

Thanks in advance.

v-alq-msft's avatar
v-alq-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi, mb0307 

 

Incremental refresh is now available to Power BI Pro, Premium, and shared subscriptions and datasets. You need to set RangeStart and RangeEnd parameters and use them to filer the data in 'Query Editor'. Then you may define the incremental refresh policy for specific table. For further information, you may refer to the document .

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.