NEW ARTICLE
This article introduces the new DAX syntax (March 2021) to support CALCULATE filter predicates that reference multiple columns from the same table.
Read more

 
NEW POST
A name is important. The right name is important. In this post, Alberto reflects on the choice of names in the Microsoft BI stack.

READ MORE

 
SQLBI YOUTUBE CHANNEL
Latest videos
Tabular tools and workspaces
32:31#unpluggedMarco Russo
Comment review: Previous Last Date
27:17#unpluggedAlberto Ferrari
Optimizing card visuals in slow Power BI reports
13:36Alberto Ferrari

 

BI-WEEKLY NEWS DIGEST
Latest news
• Support of external tools in Power BI Desktop is GA
Microsoft announced the general availability (GA) of the "external tools" feature we have been using since July 2020. This is important news for those companies worried about features support. The article includes links to several community tools – not just the famous ones!
Mar 19, 2021 · Microsoft
• On-premises data gateway March 2021 update
We are in 2021, and you still have to upgrade your data gateway manually. Thus, this reminder can be useful, right? If you use the data gateway, keep it synchronized with your Power BI Desktop version!
Mar 16, 2021 · Microsoft
• Power Query M Primer: Metadata
If you think that the user interface in Power Query is powerful, you have to find a better adjective for M (the language used in Power Query). Did you know you can use M metadata to add functions and parameters documentation? We did not, but Ben Gribaudo explains that in a great article.
Mar 17, 2021 · Ben Gribaudo
• Optimizing HR Headcount DAX Measure with Power BI
A common implementation of the Events in progress DAX pattern is the headcount. In companies with thousands of employees, performance might be an issue and the snapshot may not be enough. You also have to pay attention to the DAX measures. This post analyzes query performance in several scenarios.
Mar 27, 2021 · Sergio Murru
• DAX Studio 2.15 Released
A large number of bug fixes, many small new features to increase your productivity: read and watch what's new with DAX Studio in Darren's blog post. If you are in a hurry, just install it!
Mar 28, 2021 · Darren Gosbell
• Tabular Editor 2.15.2
The latest update includes new features for advanced properties (synonyms, group by columns) and updated TOM libraries that fix connection issues with Power BI Premium per User.
Mar 25, 2021 · Daniel Otykier
• Improving the Performance of Importing Data from ADLSgen2 in Power BI by Partitioning Tables
We have been using this trick at SQLBI for months, but we never had the time to write an article about it. Chris Webb took care of that in this blog post. FYI the same principle would apply for example if you read data from many files inside a folder named after a range of dates. Yes, there is still much to be written about this topic.
Mar 19, 2021 · Chris Webb