Use any map with Power BI

With the update of Power BI last week you can now add your own maps in any size or shape to Power BI so you can extend the set of out of the box shapes that come with Power BI. This is possible because the Shape map visual is build upon TopoJSON which is an extension of the the GEOJSON standard. This makes it super easy to add any map you want,. In this blog...

Determine slicer (or visual) influence on other visuals in Power BI

Just a quick one today as I do get this questions every now and then: How can I change which slicers interacts with a visual? By default Power BI is very interactive, anything interacts with anything but in some cases you might not want this. Excel has this build into its slicer functionality since day one but Power BI only added this in early 2016 so I can imagine some folks missed it. Let’s look...

Using multiple enterprise gateways to the same data source

Sometimes you want to be able to offload work for one of your Power BI Gateways as you might have many users who are building reports that need refreshing or are connecting live to the same data source, all of this is going over the same gateway machine, with the same CPU and bandwidth. It would be great if we can spread the load a bit but at the time of this writing the Enterprise...

Show only the sales for the last 12 months

Recently I was helping someone on the Power BI community who wanted to only see the sales for the last 12 months in his chart, nothing more. Well this is pretty simple using DAX and I decided to use variables as well. The key here is to think about what you really want and see if you can express this using DAX. In this case it is pretty simple: only show the sum of sales...

Bidirectional cross-filtering whitepaper

Bidirectional cross-filtering is a new feature for SQL Server 2016 Analysis Services and Power BI Desktop that allows modelers to determine how they want filters to flow for data using relationships between tables. In SQL Server 2014, filter context of a table is based on the values in a related table. With bidirectional cross-filtering the filter context is propagated to a second related table on the other side of a table relationship. This can help...

New role, new location

Recently I started at a new role in the Microsoft BI team as part of the customer engagement team, while it is still part of the larger BI product team at Microsoft it is no longer a active product development role. I loved working on amazing products like PowerPivot, SSAS Tabular, Power BI content packs and the Power BI desktop. I feel great knowing this is out there in the market and people love it and...

Using groups in Power BI to publish content to production on your schedule.

When developing dashboards and reports for a large group of business users you want to make sure you deploy the right content at the right time. In this article we will look at an approach that allows me to create and maintain dashboards and reports with a group of developers without disturbing the business users using the reports and dashboards and only deploy the changes to them when we deem the dashboard ready. To do...

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 in the business or even a translator. It would be nice if they had something else instead to just enter...