Forum Discussion
Capturing Data Snapshot
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
2 Replies
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 BI Blog | Microsoft Power BI
Export and email a report with Power Automate - Power BI | Microsoft Learn
Thanks
Harish MThis might also be helpful
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.
