SQLBI Newsletter #255

NEW ARTICLE

Computing MTD, QTD, YTD in Power BI for the current period

This article describes how to use the DAX time intelligence calculations applied to the latest time period available in the data, also known as the “current” period.
Read more

CLASSROOM COURSES

Dates available for 2024

You can already reserve your seat for a Mastering DAX class in 2024!

United States

Europe

Course schedule

#255 · Nov 2023

LEARNING

Course calendar

Mastering DAX

	Dec 5-7 - Cologne
	Feb 27-29 - Dallas
	Mar 4-6 - Amsterdam
	Apr 15-17 - New York City
	May 22-24 - Copenhagen
	Jun 25-27 - Chicago

Data Modeling

	Jun 25-27 - Amsterdam

video courses

	Mastering Tabular
	Intro to Data Modeling
	Data Modeling for Power BI
	Power BI Dashboard Design
	DAX Tools
	Introducing DAX
	Mastering DAX
	Optimizing DAX
	DAX Patterns

NEW ARTICLE

Where is my data?

What happens to your data in DAX Optimizer?
This article answers two key questions: what kind of data is collected in the VPAX file, and where this data is stored and processed.

BI-WEEKLY NEWS DIGEST

Latest news

	• Fabric Warehouse publishing full DML to Delta Lake Logs This is not Power BI news, but it is relevant for many Power BI developers. Microsoft Fabric offers a Data Warehouse service that can manipulate files in Delta Lake by using SQL commands. While these features raise a number of new maintenance challenges, they should not be ignored. Oct 27, 2023 · Microsoft
	• History of data warehousing If you are confused between data warehouse, Hadoop, data lake, delta lake, data mesh, data fabric, and many other buzz words that partially rename the same concepts, you should read this short recap of the last 30 years in this space. Oct 21, 2023 · Vincent Rainardi
	• Release of Power BI VSCode Extension With the Power BI VSCode extension you can manage your Power BI tenant using the Power BI REST API and modify Power BI datasets using TMDL (Tabular Model Definition Language) from within VSCode. You can also run DAX queries! Oct 30, 2023 · Gerhard Brueckl
	• How to schedule a Power BI dataset refresh to start at the exact time you want it to start You can start a dataset refresh by using Power Automate and obtain full control of the refresh time. It could also be interesting to start the refresh just after another event you control with the same flow. Oct 26, 2023 · Gilbert Quevauvilliers
	• Getting report visual IDs with Power BI Desktop Developer Mode By saving a PBIP file for your Power BI project, you can retrieve the visual ID of each element in your report and reconcile them with the information included in Log Analytics. We now need tools to automate the process! Oct 22, 2023 · Chris Webb

SQLBI YOUTUBE CHANNEL