Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
Show and Tell
Tips and Tricks
  • lbendlin's avatar
    lbendlin
    5 years ago

    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's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

 

How do you plan to store the historical information?  Does your data source have that capability or did you hope Power BI could do that for you ? (Hint: it can't - I don't think hybrid streaming datasets are an option for your scenario)

 

Have a look at Aggregations.  They work similar to the OLAP cubes of old - the aggregated tables are like the precomputed cubes, and the direct query raw tables are like the db passthrough queries.

 

For you the aggregations would be the historical data, and the direct query the real time-ish data.