SQLBI Newsletter 16/2018

NEW ARTICLE

Side effects of the Sort By Column setting in DAX

This article explains the side effects of the Sort By Column feature in Microsoft Power BI and how to write correct DAX code to avoid any issue. Read more »

OKVIZ UPDATE

Smart Filter Pro update available

A new version of Smart Filter Pro (v2.0.3) is available now.
It includes several minor bug fixes and new features, such as:

DATA MODELING

	Oct 10-12 - London
	Nov 28-30 - New York

MASTERING DAX

	Aug 20-22 - Perth
	Sep 18-20 - Toronto
	Oct 1-3 - San Francisco
	Oct 10-12 - Amsterdam
	Oct 23-25 - Copenhagen
	Oct 31/Nov 2 - Boston
	Nov 13-15 - Houston
	Nov 20-22 - London
	Dec 3-5 - Miami
	Dec 11-13 - Zurich

VIDEO COURSES

	Data Modeling for Power BI
	Power BI Dashboard Design
	Introducing DAX
	Mastering DAX
	Optimizing DAX
	SSAS Tabular
	Power Pivot

• Sync Slicers: the Smart Filter Pro selection can now be synced across every page of your reports.

• High-Contrast mode: the Smart Filter Pro now supports the high-contrast settings of Windows.
• Consolidate multiple filters: you can now bind several fields to Smart Filter Pro inside a single search box.

Latest news on Business Intelligence

	• Power BI Desktop August 2018 After two weeks from the July version, Microsoft released the August 2018 update of Power BI Desktop. The more popular features is Export to PDF, which is the way to print a Power BI report. But conditional formatting by values and data categories for measures are way more important to improve a report. Did we mention there is also Python integration? Read more »
	• Power BI new workspace experience A Power BI workspace no longer (will) require an Office 365 group. This feature is in preview, but Microsoft has a clear roadmap to replace the current experience and to make the link to an Office 365 group an option and no longer a requirement. Read more »
	• Introduction to Power BI Dataflows If you read about Common Data Model for Analytics, or about Datapools, welcome in the Microsoft favorite sport: product renaming. This month the (final?) name is Dataflows. Well, Power BI Dataflows. Maybe they will need a space? Who knows. Whatever the name, this technology is really interesting to split the transformation (Power Query) from the model (Power BI / Tabular / DAX). James Serra explains this in a short and technical blog post. No marketing here. Read more »
	• Importing from CSV or Excel in Power BI Chris Webb compared the Power Query performance importing the same data from a CSV and from an Excel file. Short result: use CSV if you can. Longer explanation and comparison chart in the blog post. Read more »
	• Modeling for Analysis Services Tabular scalability Microsoft released a whitepaper to improve data models for very large Tabular databases. These suggestions will not improve your 10 million rows database, but with billions of rows this is a must read. Read more »

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