SQLBI Newsletter #206

NEW ARTICLE

Introducing wholesale and retail execution in composite models

In composite models, any query can be executed on the remote model (wholesale execution) or by working with local and remote engines together (retail execution). This article describes the differences between the wholesale and retail modes, along with examples.
Read more

#206 · Dec 2021

LEARNING

Course calendar

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
	Power Pivot

SQLBI YOUTUBE CHANNEL

Latest news

	• Power BI December 2021 update The last update of 2021 introduces several new features in preview: sparklines, hybrid tables, and a new format pane. Sparklines are available in both table and matrix visuals. No more SVG/HTML workarounds to get the same result! Dec 15, 2021 · Microsoft
	• Public preview of hybrid tables in Power BI Premium Hybrid tables can mix a partition in DirectQuery mode with data imported in other partitions of the same table. It is an evolution of the incremental refresh, called "real time support". Only available in Premium, in reality the DirectQuery mode can be applied to any partition. Much to study and to test, as for any new feature. Dec 15, 2021 · Microsoft
	• Asynchronous refresh now available in Power BI REST API The Power BI REST API to refresh datasets now has an argument to request an email notification in case of either the failure or the completion of the asynchronous request. We would like to also be able to select tables/partitions. Currently, that is possible only through XMLA endpoint. Dec 16, 2021 · Microsoft
	• On-demand loading capabilities for large models in Power BI Large datasets in Power BI Premium can be loaded on demand by page instead of having the entire dataset loaded in memory. This can be a huge advantage for large datasets with many columns that are not used often. The article explains how to monitor the DMV that provides usage info. VertiPaq Analyzer updates coming soon to cover it! Dec 17, 2021 · Microsoft
	• Working with sparklines in Power BI At first impression, with sparklines life is easy for simple calculations. However when you start playing with more complex formulas and filters, you must understand the concept of filter context well. This blog post describes problems and workarounds when mixing date filters in a visual with sparklines. Dec 16, 2021 · Ed Hansberry
	• Troubleshooting Power BI refresh timeouts This is a three-part series dedicated to solving timeouts for Power BI refresh operations: hard limits, power query, and external commands. The issue could originate from any of these. Dec 5, 2021 · Chris Webb
	• Tabular Editor and Desktop Hardening If you ever wondered what "Desktop Hardening" means related to Power BI, this blog post provides a high-level explanation and why this is so important for tools like Tabular Editor. Nice reading also if you think you already know about it. Dec 17, 2021 · Matthew Roche

View Web Version · Status & 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.