load data directly by date slicer

[dnguyen67]

Hello,

My report file size id more than 800 MB, usage of ~5.0 GB RAM. My current dataset (sample of only 1 year data) on OneDrive is around 1.8 GB, with one of the table having 35 milions rows by days. Since I have more years and keep loading data up to date, I'm afraid the report file using more RAM to the point that my laptop wouldn't be able to handle it.

Is there a way to load data by date slicer instead of storing all data in VertiPaq Storage Engine? or is there any way to optimize my report file? one potential option I would think of is raggregating data by weeks/months, not by days.

Note: My data model is not a star schema model since they are not related to each other, only connected through date and ID keys. Do you think it is also a factor why my dataset and RAM usage are big?

[bcdobbs · Accepted solution]

If your data source was SQL you could use direct query with parameters 

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters

I'm not sure it would work with a sharepoint file.

You could look at the stats for your model using dax studio:

https://daxstudio.org/documentation/features/model-metrics/

This article gives some good pointers on reducing it:

https://radacad.com/how-to-reduce-the-size-of-power-bi-file-in-a-few-steps