Forum Discussion
Real-time and historical data of same data set
Currently, I have a report that is based on a direct query that brings in real-time data as it relates to patient exam information. In addition to providing the real-time data, I am also wanting to p...
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)
All of the data is stored on a SQL Server. I meant to say "Import" the historical data, not store it within Power BI.
Let me further educate myself on what you are suggesting as this might be a possible solution to what I'm trying to achieve.
Appreciate the feedback!