Latest posts

The new Data Modeling for Power BI course

If you import more than one table into Power BI or Power Pivot, you have a data model. When you have more than one table, you usually have relationships between tables. When you analyze data, you often have many choices between importing data as-is, or modifying the tables coming from


Power Pivot Utilities 1.09

Bertrand d’Arbonneau added a new feature in the last version (v 1.09) of Power Pivot Utilities, which allows the visualization of Dependents and Precedents measures in the measure list created by the List Measures tool. How to use the new features: Clieck List measures to create a table with a


Why I attend conferences and why I speak at conferences

I’ve recently been asked to talk about my experience as a speaker at technical conferences. I wasn’t sure what to say, until I realized that it makes more sense to start with explaining the reasons why one should attend a conference. In fact, I spent many years on the attendees


What has happened in the DAX world in 2017

We are approaching the end of 2017, 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 2018. New DAX functions in 2017 Microsoft released ten new DAX functions in


Using TREATAS in place of IN in DAX

During a conversation at PASS Summit, one of the developers of Power BI shown me a way to use TREATAS in place of IN in DAX. I am not sure it increases readability of the code, but let’s examine pros and cons. Spoiler: you should continue to use IN for


Strange behavior of HASONEVALUE and SELECTEDVALUE

I recently stumbled across a strange behavior of HASONEVALUE, which also impacts the SELECTEDVALUE function. When the only selected item in a column is a numeric value 0 and the column also contains a blank value, there is a bug in the current implementation that does not identify such a


Latest news from PASS Summit 2017

PASS Summit is the largest conference about the Microsoft Data Platform technology. Started as a Professional Association for SQL Server community, now the PASS brand includes the many technologies included in the Microsoft Data Platform. It is a large and active community, and the PASS Summit is the biggest annual


Offline model editor experience for Power BI

Professional BI developers using Analysis Services and advanced users working with Power BI share a common pain. Their productivity editing a large data model is much lower than what you might expect in 2017. There are many reasons for that. The most important ones are the automatic update of the


Why data modeling is important in #powerbi

I have a long experience in working on reporting systems based on semantic models. Now we call them “self-service BI”, but the principles are the same we had in DSS (decision support system), OLAP (on-line analytical processing), and many other names that we’ve seen over the years. The basic idea


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

Page 1 of 7012345...102030...Last »