Forum Discussion
How to keep history data and never refresh
Super UserIf the historical data is in SQL server, you can use hybrid mode: Direct Query the historical data and only import current data .
Thank you for quick response.
What is the advantages of using Direct Query in this situation? I only used import so I'm a little bit confused about your answer.
- Tutu_in_YYC
Import will create a copy of the data and store them in the power bi dataset.
Whereas Direct Query will not keep the data in the dataset, instead it will query the data source directly when you want to view the data in Power BI report. This reduces the refresh time of the dataset.
Composite mode (using both modes) is a common approach when dealing with alot of data.
The different types of modes
https://docs.microsoft.com/en-us/power-bi/connect-data/service-dataset-modes-understand
Composite mode
https://docs.microsoft.com/en-us/power-bi/connect-data/service-dataset-modes-understand#composite-modeI am already getting "insufficient memory" error. DirectQuey will use my memory more than Import data. This solution is not working for me or I didn't quiet understand what you mean.