Forum Discussion

chiragcmishra's avatar
chiragcmishra
Frequent Visitor
3 years ago

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

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

Need Help

1 Reply

  • ppm1's avatar
    ppm1
    Solution Sage
    3 years ago

    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