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)
lbendlin
Super User
Super UserAs 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)
Makes total sense. Again, I appreciate your feedback! This is very helpful information