[Help Plsss!] Daily Report Export into Compiling excel file

[DSwezey]

I have a dashboard I am creating that contains the daily cash amounts received from clients. The report I am working with is displaying the total cash amount for the current day.

My goal is to somehow export the report daily and add that to an excel file. Basically, taking a snapshot of each days cash amount, exporting the report, compiling it to an existing excel table. This way I have my own "database" that contains the exact cash amounts on those particular days. (Right now these numbers can change at any point, but I want to see the true value on each particular day).

For example, pretend the image below in white is a table result on my Power BI Dashboard.

Lets say the below table is what I currently have in the Excel file for yesterday.

I want to be able to export the first table from my BI Dashboard and add it to the above excel table to get the below compilation of my day to day cash reports. 

[v-luwang-msft]

Hi @DSwezey ，

I agree with mahoneypat. Also, you can see the following related articles.

How to Export Power BI Data to Excel (Step-by-Step)

https://www.youtube.com/watch?v=ANIZkTZO3eU 

Best Regards

Lucien

[mahoneypat]

Easiest way to do this is to publish your dataset, set up daily refresh, make a paginated report connected to that dataset, subscribe to it daily and have it emailed to you, and use a flow to write that file to a SharePoint/OneDrive location with filename for that day.  You can then combine all those files in a new Power BI dataset to analyze daily snapshot data.

Pat