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: Analysis Services
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.
Analysis Services Telemetry: What information does SSAS submit? and how has it changed in SSAS 2019?
Starting with SSAS 2016, SSAS sends some usage information back to Microsoft by default. This behavior is similar to how Telemetry works in SQL Server and SSMS and can be turned off. The first time I noticed SSAS Telemetry, it was while I was checking the SSAS Administrators group membership on a server and saw … Continue reading Analysis Services Telemetry: What information does SSAS submit? and how has it changed in SSAS 2019?
New QueryMemoryLimit setting in SSAS 2019
SSAS 2019 has a very useful new memory setting called QueryMemoryLimit that can be found under Advanced Prperties. While the online documentation says this setting is only available in Azure AS, I can see it in SSAS 2019 CTP. The purpose of this setting is limit the amount of memory any single query can take. … Continue reading New QueryMemoryLimit setting in SSAS 2019
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
Speaking at PASS Summit 2017
My session got selected for this year's PASS Summit. I am beyond excited and happy! Thank you everyone in #SQLFamily for your support. Here is my session: Build a performance monitoring toolset for SSAS using PowerBI Have you ever wanted to monitor the performance of a SQL Server Analysis Services (SSAS) server but did not … Continue reading Speaking at PASS Summit 2017
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.