Forum Discussion
Resolver IPBI Premium EM2 5GB limitations while processing/refreshing dataset
The quickest way to monitor memory usage is via temporary Analysis Services instance that is started when opening Power BI Desktop file. 1) Just open task manager and Power BI Desktop file with the problematic report(s). 2) Hit refresh all. 3) Check for ram usage spikes in task manager. That is the correct instance.
Microsoft EmployeeHi kaarel
Use measure instead of calculated column.Have a look at Vertipaq Analyzer which uses DAX Studio.
Reference:
Power-BI-in-memory-RAM-Overload
Power BI Desktop – Memory Usage
Performance Tip for Power BI; Enable Load Sucks Memory Up
Regards,
kaarelOK thanks, but how to specifically track down problematic calculated columns? Not when they are in processed/refreshed/compressed state, but when the model process/refreshing is happening and the memory consumption is growing. Vertipac Analyser doesn't help in that regard, does it?
As I said, model is 200MB, but while processing/refreshing, it grows over 5GB.- kaarel
The quickest way to monitor memory usage is via temporary Analysis Services instance that is started when opening Power BI Desktop file. 1) Just open task manager and Power BI Desktop file with the problematic report(s). 2) Hit refresh all. 3) Check for ram usage spikes in task manager. That is the correct instance.