New articles: Introducing the 3-30-300 rule for better reports
NEW ARTICLE
This article describes a simple approach that you can apply to improve your reports and dashboards.
Read more

 

SQLBI+ UPDATES

In 2023, we released the first draft of the "Window functions in DAX" whitepaper as part of SQLBI+. Since then, we have released a few updates and are now glad to announce the availability of the 3-hour video course covering the full whitepaper content.


Read more
 
NEW BLOG POST
DAX is not like M when it comes to data manipulation, and it is not supposed to be. However, if you need something in DAX similar to Table.FromList in M, this blog post is for you.
Read more

 

COURSES IN AUSTRALIA AND UK
Courses, SQLBI Days in Australia and the UK
Marco will be in Australia in August 2024 and back to London in October 2024!
Hurry, seats are limited!
These are the only dates in Australia and the UK for 2024!
Overall schedule
Mastering DAX and SQLBI Days Australia 2024

 

BI-WEEKLY NEWS DIGEST
Latest news
• Power BI May 2024 udpate
The most important announcement is that DAX Query View, Model Explorer, and authoring calculation groups are now generally available in Power BI Desktop. We know many companies needed this step to use calculation groups!
May 21, 2024 · Microsoft
• Power BI Report Server May 2024 update
Good news for those of you still keeping the service on-premises: you now have a new version available, even though you will always be jealous of the latest shiny features in Power BI Desktop and Service.
May 30, 2024 · Microsoft
• Write DAX in a semantic model
Tips and helpful suggestions to improve the DAX code you write without being an expert. The article covers Power BI Desktop, Fabric, and external tools like Tabular Editor. There are different ways to improve your productivity in each of the many editors available.
May 14, 2024 · Kurt Buhler
• Diagnosing Power BI DirectQuery connection limit problems
You can limit the number of concurrent DirectQuery connections to investigate issues that may happen in production when multiple users are using DirectQuery-based reports. Indeed, the number of multiple connections is limited by the service, depending on the capacity available.
May 19, 2024 · Chris Webb
• New Power BI Matrix layouts
The Excel PivotTable is the gold standard for all the visualization options you can desire. The Power BI matrix is far behind in terms of flexibility, even though it is way faster than its counterpart in Excel. The new Matrix layouts are the first step to bridge the gap.
May 10, 2024 · PBI Core Visuals
• Power BI Studio v2.0
Power BI Studio is a free, open-source VSCode extension that connects to your Power BI tenant and navigates assets available - including semantic models - with an integration with External Tools in Power BI Desktop.
May 28, 2024 · Gerhard Brueckl

 

SQLBI YOUTUBE CHANNEL
Latest videos