Forum Discussion
kohldorf
5 years agoNew 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 o...
Greg_Deckler
5 years agoCommunity 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.