Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
husfghk11
Frequent Visitor

Full snapshot of report in power bi service

Is there a way that I can have power bi service to send me a full snapshot of my report after the repory is refreshed daily.

I understand that current subscription can do this, but I would like to have a little more than that. The report contains a lot of tables which have breakdown and these breakdown are not expanded. Even if they are expanded, we need to scroll down the table then only we can see everything. Is there a way that I can get a snapshot (or may be export to excel) of the report all the breakdown to be captured in the snapshot as well?

1 ACCEPTED SOLUTION

It would be better to keep snapshots of the database. It would be much better to use a database that supports CDC (change data capture)

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

If you must, you can use Power Automate to schedule extracts of your PBIX file  (with the usual limitations).  The expansion of visuals depends on on the settings you specified when publishing the pbix.

 

What's the business value of these snapshots?

This is because we found out that there were changes happened in the database that we are not aware of. It was quite late when the user highlight to us and we can't replicate the numbers that our users saw. Thus, we would like to keep a copy of the pbix file and check which part has gone wrong.

It would be better to keep snapshots of the database. It would be much better to use a database that supports CDC (change data capture)

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors