Marco Russo's Blog

   View full profile
650 blog posts
Blog post –

Choosing Azure Analysis Services for large datasets

I often get questions about use cases for Azure Analysis Services. So I wanted to do a quick recap of the points I commonly discuss in these conversations, and have them readily available for the next conversation… As a bonus,…  Read more

Blog post –

VertiPaq Analyzer 2.0 Preview 1

In 2015 I released the first version of VertiPaq Analyzer, a tool to quickly analyze the structure and data distribution of a Tabular model that can be used with Analysis Services and Power BI.  Read more

Blog post –

Uncertified connectors message in Power BI Desktop

I recently had an issue in Power BI Desktop that started to display the error message “Uncertified Connectors”. What was really strange is that Power BI was not trusting… Power BI itself! I am not sure whether this started after…  Read more

Blog post –

Hate and love for the DAX language

A few weeks ago I woke up on a Saturday morning with a question notified on my Quora feed: Why do all the BI consultants hate DAX? I was challenged to answering the question because I personally love DAX but…  Read more

Blog post –

Calculation Groups in DAX – first impressions

Microsoft announced at SqlBits a very important feature for DAX: Calculation Groups. These are my first impression about the new feature and the impact it will have on Analysis Services and Power BI.  Read more

Blog post –

Why Smart Filter Pro does not use IAP

This week OKViz released Smart Filter Pro 2.0.5, which is the first commercial version of a custom visual for Power BI produced by OKViz. This is the first of other rich and advanced visuals that will be released in the…  Read more

Blog post –

Detect missing parameters in DAX queries

Yesterday I answered to a question related to parameters in DAX that could be useful to other readers who use DAX in Reporting Services (SSRS): how to manage missing parameters of a DAX query? I wrote an article in the…  Read more

Blog post –

Naming variables in DAX

There is an existing limitation in the current version of DAX, regarding what names you provide to variables in a DAX expression: a variable name cannot be the name of a table in the data model. This is not a…  Read more

Blog post –

What has happened in the DAX world in 2018

We are approaching the end of 2018, so it is a good time to review what happened in the DAX world this year, what we’ve been up to at SQLBI and what is going to happen in 2019. New DAX…  Read more