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
Category: Tabular
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
Cannot update VertiPaq Analyzer’s connection to point to my SSAS Tabular database
While trying to set up VertiPaq Analyzer on a new computer, I ran into a problem where Excel was not letting me change the SSAS connection that was built in the workbook. It turns out I had missed one of steps in the instructions in the workbook. As a result, when I got to Connection … Continue reading Cannot update VertiPaq Analyzer’s connection to point to my SSAS Tabular database
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.
How to change the font size of the formula bar and measures grid in SSDT for SSAS Tabular
When you create a new measures in SQL Server Data Tools (SSDT) for SSAS Tabular, you edit the formula in the top section of the user interface in a section called "formula bar". The default font size for this formula bar is 8. The small font size may be difficult to read for some people. The easiest and fastest way to change the font … Continue reading How to change the font size of the formula bar and measures grid in SSDT for SSAS Tabular