
SSAS Tabular Translator
SSAS Tabular Translator is an editor for the JSON translation files exported and imported by SQL Server Data Tools, for a Tabular model compatibility version 1200 or later. Free download
Small benchmark for Tabular and Power BI formula engine (FE) #ssas #tabular #powerbi
If you run SSAS Tabular or Power BI, please help me in gathering some performance data for a study I’m doing about Formula Engine performance following these steps: 1) Copy the PowerShell code below in a script Benchmark.ps1, modifying serverName, ssasInstanceName Read more
New edition of the Analysis Services Tabular book #ssas #tabular
Last year I and Alberto Ferrari wrote a new edition of the Analysis Services Tabular book, which official title is Tabular Modeling in SQL Server Analysis Services (2nd Edition) . Some delay in editing and production delayed the printing, but the book Read more
Using and optimizing DirectQuery in #powerbi and #ssas #tabular
More than one year ago, I and Alberto Ferrari started to work on DirectQuery, exploring the new implementation appeared in Analysis Services 2016 for the Tabular models, which uses the same engine of Power BI. The previous version of DirectQuery appeared Read more
Using SUMMARIZECOLUMNS instead of SUMMARIZE in #dax #powerbi #ssas #tabular
One of the latest addition to DAX has been the ability to apply an external filter context to SUMMARIZECOLUMNS, which makes this function a perfect replacement for SUMMARIZE in DAX. In The Definitive Guide to DAX I introduced such a function, but at the Read more
SSAS Events Analyzer
SSAS Events Analyzer is a simple monitoring system that can be easily applied to any SSAS server with minimal effort. Free download
SSAS Activity Monitor
SSAS Activity Monitor is an open source tool to monitor the current activity (sessions, transactions, connections, and locks) on an Analysis Services instance. It works for both the Tabular and Multidimensional mode. Free download
VertiPaq Analyzer 1.7: a fundamental tool for #powerbi #powerpivot #ssas #tabular diagnostics and documentation
If you work with Power Pivot, Power BI, or Analysis Services Tabular, you probably already know VertiPaq Analyzer. If you never used it, with the new release 1.7 you have another couple of very good reason to try it. VertiPaq Analyzer is a Power Pivot Read more
Santa Claus brings presents to #dax, #powerbi, and #ssas #tabular users
If you think that the end of the year would have been a quiet time because the Power BI team will skip their monthly release (but are we sure?), you might be reassured (or disappointed depending on your perspective) looking at the news I have in this Read more
DAX Editor 2.0 finally available: it is a must have for #ssas #tabular #dax developers
The SQL Server Data Tools (SSDT) editor for Tabular models has been improved in the recent updates. For example, the Tabular Model Explorer enables you to quickly jump between the entities of your model organized in a hierarchical way. However, when it Read more