Forum Discussion
How to keep history data and never refresh
Super UserImport 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-mode
I 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.