Capturing & Storing Previous Day's Data

Hi team,

Looking to get some expert guidance. I have a situation where i am creating an Opportunity Funnel dashboard based off data that i receive from my data warehouse (it get’s sent as an excel file to a shared network drive daily) however my sales organisation wants to see the opportunity values the previous day (as the sales team are instructed to update their Opps daily).

From what i understand PBI doesn’t support incremental refreshes of data so I’m hoping to get some advise on how to store the previous day’s values when the data is refreshed daily.

Thanks in advance!


I dont have alot of experience with this, but have you tried:


Thanks to the contributors of this post. Due to the length by which this post has been active, we are tagging it as Solved. For further questions related to this post, please make a new thread.