Forum Discussion
Impactful IndividualOptimize Service memory usage
Impactful IndividualWe did some tests by uploading a second report non 'used' version of the same. During report usages and refresh we didn't saw a behavior of what you're suggesting. Is there any documentation on the basis what you're referring to?
Note for the Direct Query would be that you would put stress on the server capacity by making requests each time it is used. We don't know how both would size up when compared to each other.
Solution SpecialistDouweMeer I would start with these two docs.
Import: https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction
DirectQuery: https://docs.microsoft.com/en-us/power-bi/guidance/directquery-model-guidance
- DouweMeer
Thank you for your links. However when reading through them, I don't see something mentioning that when you import data: "So when you are using Import mode for your tables, whenever the report is used, the dataset is loaded into the capacity's memory".
It only mentions that when you publish a report, the compression ratio's vary when available in Service. That during the publish/ refresh state the VertiPaq storage engine is deals with an increased memory usage, but nothing is mentioned when an end user requests a dashboard of the data model.
- JirkaZ
DouweMeer It's by definition. Power BI is SSAS Tabular in memory. So whenever you want to retrieve data, it's from memory. So when you want to view a report, the model is loaded from storage into memory and only then you can view it.
- DouweMeer
That sounds worrying. So if I have the statement:
calculate ( countrows( selectcolumns ( A , "test" , A.A ) ) , userelationship ( A.B , B.A ) )
You're suggesting the whole table created after an inner join of A and B is stored in RAM during the time the user is accessing the dashboard?