SQLBI Newsletter #179

NEW ARTICLE

Using calculation groups to switch between dates

This article (+ video) explains how to use calculation groups to change the active relationship in a model, in order to let users choose among multiple dates.
Read more

NEW ARTICLE

Optimizing memory settings in Analysis Services

This article describes the memory configuration in SQL Server Analysis Services and Azure Analysis Services. Modifying these settings may impact performance and trigger memory errors.
Read more

#179 · Dec 2020

LEARNING

Course calendar

video courses

	DAX Patterns collection
	Intro to Data Modeling
	Data Modeling for Power BI
	Power BI Dashboard Design
	Introducing DAX
	Mastering DAX 2
	Optimizing DAX
	SSAS Tabular
	Power Pivot

DAX PATTERNS

Parameter table

The parameter table pattern is used to create parameters in a report, so that users can interact with slicers and dynamically change the behavior of the report itself. For example, a report can show the top N products by category, letting the users decide through a slicer if they want to see 3, 5, 10 or any other number of best products. The values available for a parameter must be stored in one or more disconnected tables, which do not have a relationship with any other tables of the same model.
Read more

SQLBI YOUTUBE CHANNEL

Latest news

	• Delaying Power BI dataset refresh until the source data is ready This blog post explains how to pause the data refresh of a Power BI dataset if the data source is not ready at the scheduled refresh time: Power Query can do that! Nov 22, 2020 · Chris Webb
	• New export settings in the Power BI admin portal The Power BI administrators have more control over the export data options available to the users. Settings available: download report and export to CSV, MHTML, Word, and XML. Read the article to understand the default behavior of these options, and the impact on existing tenants. Nov 24, 2020 · Microsoft
	• Change partition configuration for data in Power BI Premium Using DAX Studio and VertiPaq Analyzer, you can evaluate the impact of partitions created by using incremental refresh policies in Power BI. Once you understand the organization of the data, you can optimize the data distribution across partitions. Dec 2, 2020 · Gilbert Quevauvilliers
	• Tabular Editor 2.13.2 The latest release of Tabular Editor improved the speed to load the list of databases connecting through the Power BI XMLA endpoint. Dec 4, 2020 · Daniel Otykier
	• Moving on-premises AS and RS BI solutions to Azure Microsoft does not provide Analysis Services Multidimensional and SQL Server Reporting Services as services on Azure. However, new ready-to-use virtual machine images optimized for this workload are now available. The article also mentions that there are no plans to launch a PaaS service for multidimensional workloads. If that is something you want, write your feedback in the comments of the article! Nov 1, 2020 · Microsoft

View Web Version · Change Email Preferences · Unsubscribe

You are receiving this email because you have registered to a mailing list from sqlbi.com. If you would like to avoid similar emails in the future, please change your email preferences by clicking the link above.