Forum Discussion
Real-time and historical data of same data set
As v-lionel-msft mentioned - you should store the historical data at the source and access it as needed (via Direct Query) and load the frequently needed current data into memory (using import mode, but just for a small portion of the data)
Community SupportHi Anonymous ,
Is there no historical data stored in your data source(SQL Server)?
You should store historical data in the data source, and then use the "Direct Query" mode to connect to the data source and display real-time data and historical data in Power BI.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes, all of the historical data is stored within SQL Server. Currently, I have a PBI Report that is based on a Direct Query that is pulling the most recent data (every 15 min.) as it relates to Scheduled Exams for today's date. In addition to this, I am also wanting to give the users the ability to look back in time. At this point, I'm thinking of Importing all of the data (3 yr. lookback) as opposed to Direct Query and refreshing it every hr. I was trying to achieve the best of both worlds, but I don't think it's necessary to refresh the data that often (each hr. should suffice).