How to kill idle SSAS sessions and connections in a batch

While connections and sessions don't take much memory compared to what the actual SSAS data does, they still take some memory that can be valuable to free up if a server is under resource pressure. SSAS routinely checks the amount of time elapsed from a session/connection's last command and if it has been idle for … Continue reading How to kill idle SSAS sessions and connections in a batch

Connecting live from Power BI Desktop to SSAS generates this error: The Server you’re trying to connect to doesn’t have any models or you don’t have permissions to access them.

I recently ran into an error while connecting live from Power BI Desktop to a SSAS server. Everything was on-premises.There was no cloud component involved. I had full admin rights to the SSAS server and could see all databases and models from SSMS and other tools but was getting this error from PBI Desktop. The … Continue reading Connecting live from Power BI Desktop to SSAS generates this error: The Server you’re trying to connect to doesn’t have any models or you don’t have permissions to access them.

Understanding SSAS memory settings with real examples

If you have worked with SSAS and been responsible for if from the server side, you are most likely familiar with its memory settings. In an ideal world, your server has plenty of physical memory, so you don’t have to worry about these settings. In a real world though, you may have one or more … Continue reading Understanding SSAS memory settings with real examples

How to clear SSAS cache using C# for query performance tuning

First let me give you a little background of why you would want to clear SSAS cache from C# code when you can do this using an XMLA command from SSMS. If you have a slow MDX/DAX SSAS query , you have a couple of options for improving the performance (assuming no hardware changes): Rewrite … Continue reading How to clear SSAS cache using C# for query performance tuning

Build a Performance monitoring tool for SSAS using Power BI

Build a performance monitoring tool for SSAS using free out of the box Windows tools and Power BI Desktop

Calculated measures in Power BI Desktop reports connected live to SSAS Tabular.

May release of Power BI Desktop adds the capability of adding new calculated measures to a report when you are connected live to SSAS tabular. This is great because before this release, once you connected live to SSAS you could not make any changes to the model. Official announcement Ideally the SSAS database has all … Continue reading Calculated measures in Power BI Desktop reports connected live to SSAS Tabular.

Clear Cache XMLA for SSAS Multidimensional

I often use the following XMLA code to clear database/cube/measure group cache in SSAS Multidimensional when I do performance testing between different MDX queries or versions of the same database. I am posting it here so that I can find it easily in future. You can use it to clear the cache at the database, cube or … Continue reading Clear Cache XMLA for SSAS Multidimensional