SQLBI Newsletter #138

NEW ARTICLE

This article shows why building custom Date tables is preferable to using the automatic date/time handling capabilities of Power BI. Read more »

NEW ARTICLE

This article describes how to correctly use column references when manipulating tables assigned to DAX variables. Read more »

#138 – May 2019

COURSES HIGHLIGHT

• Last days for Early Bird of Mastering DAX courses:

Aarhus, DK – June 18-20

• Learn DAX in July:

Brisbane, AU – July 17-19

Sydney, AU – July 30-Aug 1

• Learn data modeling in Australia:

Melbourne, AU – July 23-25

NEWS DIGEST

Latest news on BI

	• Report commenting for Power BI service and mobile It is now possible to insert comments in Power BI reports, sharing them with other people in the company to discuss pages or specific visuals. This is a very long awaited feature in many companies. Read more »
	• On-premises data gateway May 2019 This month the data gateway update includes an important new feature (Gateway Performance Monitoring) to help investigating in performance issues and bottlenecks in slow refresh activities through the gateway. As usual, upgrading the data gateway is always a good idea to keep it aligned with Power BI Desktop. Read more »
	• Extracting all the M code from a Power BI dataset using the DISCOVER_M_EXPRESSIONS DMV Chris Webb wrote an interesting blog post describing how to retrieve the M code of all the query expressions in a Power BI model. This technique uses the DISCOVER_M_EXPRESSIONS data management view, which unfortunately is only supported in Power BI service and not in Power BI Desktop – but Chris explains how to use this technique even without Power BI Premium! Read more »

You are receiving this email because we have registered your interest in SQLBI.
unsubscribe me - Privacy Policy