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 whe...
Need Help
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