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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
kohldorf
New Member

Create Monthly Snapshots txt files from multiple sources

Dear community,

 

Im quite new with Power bi, and I wanted to ask you if its possible in Power Query to extract data from a few sources and this outcome, create monthly snapshot, apending them in one file with all these snapshots or create one file per snapshot. How could I do this?

 

Thank to all of you!

2 REPLIES 2
edhans
Super User
Super User

@kohldorf you can look at Chris Webb's method here, but as @Greg_Deckler said, this is kinda ugly. I would not recommend generally putting this into production. Power BI is not designed to create snapshots, and this Incremental Refresh hack is, well, a bit of a hack. 😁 It is a very cool article and interesting. If you republish though you wind up whacking your earlier data. then you get into using the ALM Toolkit to preserve partitions in the service holding old data, etc.

 

Your best bet is to use a front end process to have two sources of data - current and previous. Then report on those differences in Power BI.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Greg_Deckler
Community Champion
Community Champion

@kohldorf - Snapshots like what I think you are talking about are really difficult in Power BI. I assume you want to have a table that saves the history of each data refresh? That's really, really manually intensive. You basically have to create a query per load to create a new table in the data model, then disable refresh, copy query to a new query, rinse and repeat. It's ugly.

Maybe @ImkeF or @edhans have a trick up their sleeves.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors