Forum Discussion
Memory issue after Power BI April update ?
My model is built on Power BI Desktop, importing data from sql server DB. the model size is not so large :45 Mb.
the visual that trigers the vast memory usage is a pareto% :
TotalNetSalesAllClients := CALCULATE([Total Net Sales],All(DimClients))
AccountRank := RANKX(ALL(DimClients),[Total Net Sales],,DESC)
ParetoValueAccount := SUMX(TOPN([AccountRank], ALL(DimAccounts),[Total Net Sales]),[Total Net Sales])
Pareto%Accounts := DIVIDE([ParetoValueAccount],[TotalNetSalesAllAccounts],BLANK())
when writing it I see that there is an inconsistancy with the use of DimClients vs DimAccounts (they are the same one ..).
basicly the original name was DimClients wich I later change to DimAccounts, assuming that the model can handle it-and it did.
I now assume that the upgrade of the model file didn't handle that change correctly and was kinda "searching" a non existing DimClients until memory error.
I am checking this now and will write back if this is correct.
My Bad. the source code was taking from my documentaion and not from the model.
the measures from the model all point to the relevant DimAccounts.
My assumption was wrong..