Forum Discussion
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 o...
edhans
Community Champion
Community Championkohldorf 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.