-
This blog is usually dedicated to Business Intelligence and SQL Server, but I didn’t found easily on the web simple PowerShell scripts to help me deploying a number of virtual machines on Azure that I use for testing and development.… Read more
-
This blog is usually dedicated to Business Intelligence and SQL Server, but I didn’t found easily on the web simple PowerShell scripts to help me deploying a number of virtual machines on Azure that I use for testing and development.… Read more
-
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,… Read more
-
If you want to detect if a particular instance of Analysis Services “Denali” is running in Tabular or Multidimensional mode, you have several choices. In the Books On Line you can find a few instructions to detect the version by… Read more
-
I recently wrote an article about how to implement a Process Add on a table in a Tabular model. This is an area where there is a lack of documentation by Microsoft, especially if you want to use a custom… Read more
-
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… Read more
-
Did you ever experience a long waiting time while opening a Power BI Desktop file? There could be many reasons for that, but if you have calculated columns and/or calculated tables in your model, you should be aware that they… Read more
-
When working on the Mastering Tabular video course, we needed a sample database with more data than what we had at our disposal in existing sample databases. We also wanted to be able to control the content so that different… Read more