We have Power BI Report server based reports that connect to SSAS Tabular Models (SQL Server 2017).
We recently tried upgrading our VM , adding in more cores (4 to 😎 and RAM (64 to 128GB). This ended up making performance of reports/dashboards worse. When we reverted back the configuration things are fine again.
We specifically noticed a strange scenario with the upgraded configuration. When I ran a certain MDX query as myself (I'm setup as an admin on the server) in SSMS Browser mode it ran in a 2 secs but the exact same query took >30secs when I was impersonating another user (we do have a fairly complicated row level security logic built into the models). With the older VM configuration it only took about 5-6 secs in impersonated mode.
Any reason why there is such a huge difference with the addition of cores/RAM? Any tips on how I can go about understanding this better?
