Reply
spandy34
Responsive Resident
Responsive Resident
Partially syndicated - Outbound

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 2
tamerj1
Super User
Super User

Syndicated - Outbound

@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
Solution Sage
Solution Sage

Syndicated - Outbound

@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

avatar user

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)