Forum Discussion
ML Aggregations Storage Durations in PBI
Hello,
I have a semantic model which uses ML Aggregations. However, the data is refreshed monthly and will be used by stahkeholders only during the beginning of the month. I want to userstand if the ML aggregations get stored for a month's time. Or will it have to updated every month for smooth user experience.
Thanks!
Power BI's automatic ML aggregations persist until the next data refresh. They are stored in an in-memory cache and remain available for query acceleration until the semantic model is refreshed. Since your model refreshes monthly, the aggregations will remain valid and effective throughout the month. For more information please refer the help page - https://learn.microsoft.com/en-us/power-bi/enterprise/aggregations-auto
2 Replies
- BhavinVyas3003
Super User
Power BI's automatic ML aggregations persist until the next data refresh. They are stored in an in-memory cache and remain available for query acceleration until the semantic model is refreshed. Since your model refreshes monthly, the aggregations will remain valid and effective throughout the month. For more information please refer the help page - https://learn.microsoft.com/en-us/power-bi/enterprise/aggregations-auto
Hi V_S27
Thank you for reaching out to the Microsoft Fabric Forum Community.
And also thanks to BhavinVyas3003 for Prompt and helpful response.Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.
If the response addressed your query, kindly mark it as Accepted Solution and click Yes if you found it helpful this will benefit others in the community as well.
Best regards,
Prasanna Kumar
