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
This article explains how to use KEEPFILTERS to intersect instead of overriding an existing filter context in DAX, simplifying the code and improving performance.
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
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
This article compares the differences between calculated columns and calculated tables from a processing and storage point of view.
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
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
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.
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.
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.