Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
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!
@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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting@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.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.