Topic: Power BI

       76 blog posts of 164 posts
blog post –

A small change in DAX Formatter and in DAX formatting rules

DAX Formatter was created in 2013 to help users format their code based on the Rules for DAX Code Formatting published in October 2012. Because the main goal is to make the code immediately readable and recognizable, DAX Formatter purposely…  Read more

blog post –

What has happened in the DAX world in 2019

Another year has gone by and it has now been 10 years since DAX was first introduced in late 2009. As usual, it is time to review the past year and to take a look at the year ahead.  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 –

Using DAX with DateTime values

I was recently reading an interesting question by a user. Given a date/time value and a number of hours, add the number of hours to the date, but considering some constraints related to working hours: The working hours are 09:00-17:00…  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 –

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

blog post –

Displaying a list of selected months

Today I woke up with an interesting question, about how to show a selection of months in a nice way, detecting contiguous selection. You can easily understand the desired solution from the following figure: I enjoyed writing a quick solution,…  Read more

blog post –

DAX Studio and Power BI diagnostic port

DAX Studio connects to a Power BI Desktop model using a technique that was not officially supported until a few months ago. This changed when the “diagnostic port” was documented in this article of the official documentation:  Read more