As per the title, I have a test tabular cube deployed to SSAS. The model itself is very small, only about 2mb in size, however when I try to import it to PowerBI it's throwing an out of memory exception. The model itself only has a few thousand rows.
Why is PowerBi using up so much memory for such a small import? It's eating up the RAM on the machine and then throwing an exception.
Googling this problem gave a few results:
Here https://community.powerbi.com/t5/Desktop/Not-Enough-Memory-Error/td-p/193818 it's described that memory issues in the SSAS server might cause similar problems.
Here https://mydataodyssey.blogspot.com/2019/03/power-bi-olap-import.html is a blogpost describing how Power BI creates as unefficient query to the SSAS cube, which might cause memory issues.
As @Jon said, with SSAS tabular cubes, it's best to use Live Connection instead of import.