Marco Russo's Blog

   View full profile
670 results

Setting the right permissions for users of composite models

When you create and publish a composite model using DirectQuery for Power BI datasets and Analysis Services, you should pay attention to the minimal permissions required to consume data. For example, consider the following scenario: Base is a shared dataset…  Read more

Common mistakes in big data models – Live Event

Don’t miss the upcoming free SQLBI live event on Friday April 16, 2021! Join Adam Saxton, Alberto Ferrari, Patrick LeBlanc, and Marco Russo to discuss common mistakes in big data models. Proper data modeling will be a hot topic in…  Read more

Introducing DAX.do

DAX.do is a new website by SQLBI where you can write and run DAX queries over a sample Contoso database. The goal of DAX.do is purely educational: if you are learning DAX or are merely curious to test a new…  Read more

Testing SQLBI Live Q&A

In the past few months, we delivered an increasing number of sessions online. It did the job as a replacement for in-person events, but we did not particularly enjoy the lack of interaction among other limitations. We want to provide…  Read more

What has happened in the DAX world in 2020

At the end of a year marked by the pandemic, it is time for our usual review of what happened in the DAX realm. The enthusiasm we typically demonstrate in this traditional end-of -year post is tainted this year by…  Read more

The hard truth in numbers

We all have biases. Personally, I kick myself whenever I identify that I have applied my biases when doing an evaluation of any kind. Unfortunately, this happens often because I work with numbers every day. Do you think we at…  Read more

Default calculation item in calculation groups

Power BI offers several options to create filters and slicers in a report. However, it is not possible to define a default filter at the model level so that every new report on a dataset automatically applies that filter. The…  Read more