Power BI

ARTICLE

Missing automatic update of Data Gateway for Power BI

Recently Microsoft unified the Data Gateway so that you have a single gateway for Power BI, Azure Analysis Services, Power App, Flow and maybe much else. However, it seems that automatic updates are not even planned at the moment as a feature for the Data Gateway. I understand that there

ARTICLE

Using KEEPFILTERS in DAX

This article explains how to use KEEPFILTERS to intersect instead of overriding an existing filter context in DAX, simplifying the code and improving performance.

ARTICLE

Power BI Visuals Reference

Power BI is a great tool that includes several high quality charts. In addition to the built-in ones, there are more than 100 custom visuals that you can get for free from the Office Store or import directly from Power BI itself. How to choose the right visuals for your

ARTICLE

The easiest way to start using variables in #dax

A few months ago, I and Alberto realized that the reason why variables are not used in DAX as they should is that… there are not many examples out there! For this reason,¬†we made a commitment to use them more often in our example. We didn’t do that in 2015

ARTICLE

Storage differences between calculated columns and calculated tables

This article compares the differences between calculated columns and calculated tables from a processing and storage point of view.

ARTICLE

Sessions and preconference at Microsoft Ignite and PASS Summit

In the second half of 2017 I will deliver sessions and preconference days in two big events. I’d like to recap my sessions here, let me know if you have any questions about them. Microsoft Ignite 2017 – September 25-29, 2017 – Orlando, FL Preconference full day – September 24

ARTICLE

Local #dax measures in #powerbi reports are not visible from #Excel

You can connect an Excel workbook to a Power BI model in two ways: Using the Analyze in Excel action in powerbi.com Using the Connect to Data action in the ribbon of Power BI publisher for Excel In both cases, you have the ability to choose either a report or

ARTICLE

Generating a series of numbers in DAX

This article describes how to create a table with a series of numbers in DAX by using the new GENERATESERIES function or through a workaround using CALENDAR.

ARTICLE

Changing the culture of a Power BI Desktop file

This short article explains how to change the culture settings of a Power BI Desktop file, which by default corresponds to the locale settings of the machine used to create a Power BI Desktop file.

ARTICLE

Measuring the dictionary size of a column correctly

This article explains how to correctly measure the dictionary size of a column in a model created in Power BI, Power Pivot, or Analysis Services Tabular.