Daily snap shot of data then append data to one table

[Anonymous]

Hello. I am trying to create a dashboard that would extract data from an online service(salesforce reports) and only show the data for the day, so a daily snapshot of everything that happened from 6 AM to 6PM (12 hours). Then take that data and append it to a table, then the following day take another snapshot of the data for those 12 hours and append it to the same table and have this continue throughout the year. 

reason for taking a daily snapshot is when we refresh the data source the information changes and trying to analyze trends from a day to day perspective.

I was thinking maybe incremental refresh but i believe I would have to change the parameters everyday for the next day and not include the previous day, hoping to automate this. 


Example:
Day is Monday, take snapshot of data for 12 hours(6 AM - 6 PM), append data to table. Tuesday take snapshot of data for 12 hours append data to table, that way we can show performance from day to day. 

Is this possible within PowerBI?

[edhans · Accepted solution]

No. Power BI refreshes are meant to wipe/replace data. It is not a datawarehouse that creates data.

There is an interesting incremental refresh trick here, but if you ever republish the PBIX, it wipes out all history, and there isn't a backup strategy. I would never use this hack for valuable data or in production. So you will need another mechanism to create and save the snapshots. Then use Power BI to report on it.