New article: Using DAX to control a chart range in Power BI
NEW ARTICLE
You can rely on DAX expressions to control the behavior of some aspects of Power BI visuals. This article shows a few examples of how to manage the range of charts.
Read more

 

LIVE EVENT
Having been active participants and speakers at SQLBits for numerous years, we are absolutely honored to reveal the official details for SQLBits 2024!

Thursday, September 14, 2023, 13:00 UTC

Live on YouTube, LinkedIn, Facebook, Twitch
Read more

 
PREVIEW
PBI Explorer is a new, free tool that provides a code-first view of a PBIX report. All visual properties, settings, and relationships are fully exposed in Tabular Editor style, with a git-like diff view between two versions of the same report. The first preview version will be released very soon, you can register to receive a message when it is available.
Read more

 

BI-WEEKLY NEWS DIGEST
Latest news
• Tabular Editor 2.20
The latest version of Tabular Editor 2 (the free version) includes bug fixes and support to the latest TOM libraries, which improve the performance when you connect to Power BI through the XMLA endpoint.
Aug 6, 2023 · Daniel Otykier
• Understanding the “External table is not in the expected format” error in Power Query
If you have seen this error while importing data from a file in Power BI or Excel, you have a mismatch in the file type. Good to know there is now an article explaining it.
Aug 27, 2023 · Chris Webb
• On-premises data gateway August 2023
Another month, another gateway release. Did you really wait for our newsletter to remind you of the update?
Aug 28, 2023 · Microsoft
• Privacy levels in dataflows: impacted by staging?
Talking about Power Query, there are new features in Fabric (such as "enable staging") that have implications on privacy levels. It's never easy.
Aug 29, 2023 · Ben Gribaudo
• How to set table or matrix column widths in a Power BI report
Do you want to set the width of a column in a Power BI matrix? You cannot. Well, you can, but you have to use the new PBIP format. It's possible, it's still not easy.
Aug 29, 2023 · Kurt Buhler
• DAX Optimizer – First impressions!
DAX Optimizer is still in private beta, but more and more people are receiving the invitation to test it and we already have the first reviews. And they seem to be positive! Here is the first in English.
Sep 6, 2023 · Nikola Ilic
• Power BI VertiPaq engine: Optimizing column encoding
Value encoding, hash encoding: though we have covered this topic in the Mastering Tabular video course and in conference sessions, there are not enough articles available about the topic showing different points of view. Here, you can see how to modify the encoding of many columns by using scripts in Tabular Editor 2.
Sep 6, 2023 · Kristyna Hughes
• 12 Reasons for using Dimensional Model
There should probably be an article like this every month. People new to data analytics often confuse a methodology with the tools of the trade. The methodology doesn't age just because the tools of the trade change.
Sep 2, 2023 · Vincent Rainardi
• Building Dimensional Model on Data Lakehouse
What is (should be) a Data Lakehouse? Here you can read a clear explanation in less than 700 words, with schemas and sample code. The dimensional model is here to stay.
Sep 4, 2023 · Vincent Rainardi


SQLBI YOUTUBE CHANNEL
Latest videos