Capturing Data Snapshot

[spandy34]

I have created a PBI Report in Desktop and published it to the Service.  It contains one data table and date table.  It refreshes twice a day.  I want to capture the table each day so I can report on the data on a specific date in the past.  Is there a function where PBI will copy the table each day and automatically export it and date stamp it so I can then report on it?

@amitchandak @tamerj1 @Anonymous 

[tamerj1]

@spandy34 

This might also be helpful 

https://www.thebiccountant.com/2022/10/11/when-a-power-bi-dataset-refresh-completes-trigger-in-power...

however, the data exported us limited to 100k rows. Can be split into multiple files if the data is larger than 100k rows. There is a youtube video from DAX Fridays that explains how to do that. 

[HarishKM]

@spandy34 Hello,
You can use power automate to download and send an email or  other option also available.
Kindly refer below documents.

Power Automate actions for exporting Power BI and paginated reports now available | Microsoft Power ...


Export and email a report with Power Automate - Power BI | Microsoft Learn


Thanks
Harish M