Tabular translator for SQL Server 2016 on github

With the just released CTP 3.3 for SQL Server 2016 Analysis Service we can now provide translations to your Tabular models. As you might have seen in the blog post you can export a file from SSDT that can be used to translate the model. But often you want to give this file to someone… Read More »

Dynamic format using DAX

Just a quick blog post today. Someone had a scenario where they wanted to have a different number of decimal points based  on the items on the rows. Initially they wanted to go with a calculated column but it is much easier to do this using the FORMAT function in DAX. Using the FORMAT function… Read More »

DAX now has variable support!

With the latest release of the Power BI designer that now supports measure creation we also snuck in another feature that is very useful in complicated measure scenario’s and for performance optimizations. DAX now supports variables. Lets take a look at what that means.

New version of the Power BI designer now supports DAX

As most of you probably have seen or heard, the Power BI designer now supports some of the Power Pivot features like DAX and renaming columns, formatting etc. Some of the features: Formula bar: Using the new formula bar in the Report view you can create measures by writing formulas in the DAX language. The… Read More »

Sessions at SQLBits

I am very happy to share that I’ll be doing several sessions at the SQLBits conference this year. I will be doing the following sessions: We now have an exciting developer story for Power BI, the session Developing for Power BI I will go into how to write applications for Power BI and show you… Read More »

Power BI news

You probably have heard the news already but we have some exciting information that has been released on the new Power BI service as you, for all the details read the blog post on Microsoft. Some great new functionality that is being released are: – Dashboards that allow you to gain insights in your data… Read More »

Loading an image into the Model using Power Query

Last week I had an interesting questions, someone wanted to show images in Power View but didn’t want the report to have to fetch the images every time. So the images needed to be loaded into the model. I have this simple Device table that I loaded from Azure into Power Query:  

New year and several updates

As most of you have probably noticed I have not been very active recently, this has everything to do with the recently released preview for Power BI that took all my time. Luckily now that we shipped the first preview I hope to be able to spend some time on blogging again, mostly on the amazing… Read More »

Automatically ranged date table using DAX and M

I am prepping some demo’s for my SQLPass summit session “End-to-End Demos with Power BI” where I’ll show many of the tricks I use in my Power BI workbooks. One of them is this trick that I recently figured out, I am so excited about it that I wanted to share it with all of… Read More »