Add Rows from data source on refresh, instead of updating rows

[chiragcmishra]

I have a data source Excel file, that is going to be edited every day by end users. I want to create a Power BI report which takes the data source file, runs a query to get a table, and every day when it refreshes, new rows should be added to the Power BI table, instead of updating existing rows. 

For e.g. a simple table with three columns and one row

Day 1 - Source Table -

C1      C2       C3

A        11        xyz

(Refresh Dataset)

Day 1 - Power BI table - 

C1      C2       C3

A        11        xyz

Then, 

Day 2 - Source Table -

C1      C2       C3

B        12        mno

I want 

Day 2 - Power BI table - 

C1      C2       C3

A        11        xyz

B        12        mno

[ppm1]

Power BI doesn't store data that way. Two options to consider that both involve Power Automate.

1- a daily flow that creates and names (with the date) a copy of your Excel file. Your Power BI report is then built combining those Excel files.

2- a daily flow that queries your dataset after refresh and stores the data in a new csv file (on SharePoint or other place). Your Power BI report is then built combining those csv files.

Pat