Dataset refresh and high memory usage error

[rka_sd]

Why does PowerBI insist on using its own memory when the dataset is a connection to a Azure Analysis Services Model. It's the job of the AAS and not PowerBI. 

[v-rongtiep-msft]

Hi @rka_sd ,

What is your connection mode? Import or live connection? Both Connect live and Import options are supported. However, we recommended you use live connections because Import mode does have some limitations.

To safeguard the performance of the system, a memory limit is enforced for all queries issued by Power BI reports against Azure Analysis Services, regardless of the Query Memory Limit configured on the Azure Analysis Services server. You should consider simplifying the query or its calculations if the query is too memory intensive.

More details :Request Memory Limit 

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.