Don't miss Marco joining Guy in a Cube in the Q&A live event on Saturday, November 13, 2021!

Microsoft announced at Ignite the upcoming Hybrid Table feature in Power BI. While that feature is expected in December, it is a good time to discuss all the options available for reducing to get data updates in a report: DirectQuery, Hybrid Tables, Push Datasets, and Incremental Refresh.

The event will be live on YouTube - set a reminder now!
Set Reminder

Creating real time dashboards in Power BI with push datasets 28:52 #article Alberto Ferrari

IF 02:41 #daxguide Alberto Ferrari

SWITCH 04:18 #daxguide Alberto Ferrari

COALESCE 02:01 #daxguide Alberto Ferrari

	• Power BI announcements at Microsoft Ignite Microsoft announced a few features, just released or coming soon. News on Goals, Purview integration, and improved Teams integration are included. But our attention is mainly on Hybrid tables, coming in December 2021. If you are interested in that hot topic, watch the Q&A live event on Nov. 13 announced in this newsletter. Nov 2, 2021 · Microsoft
	• Excel and Power BI better together Besides a recap of the recent features that improve the usability of Power BI datasets in Excel PivotTables, Microsoft announced a long-awaited improvement in Power BI export to Excel: you can export the content of a Matrix visual preserving the layout (colors, formatting, and so on). Nov 2, 2021 · Microsoft
	• Source control and DevOps for Power BI Action BI Toolkit solves a long-standing problem in the Power BI development community. It provides tools to bring Power BI projects under source control, enabling professional development workflows and enhanced governance. It is free, open-source, and unsupported by Microsoft - as it was DAX Studio at the beginning! Nov 7, 2021 · Release notes
	• Refreshing Power Pivot Excel data models that use the current workbook as a data source in Excel Online Title translation: you can publish a PowerPivot model in Excel to OneDrive/SharePoint/Power BI and it just works. You can do in Power BI service what you did in SharePoint on-premises ten years ago. Well, actually more. Just Power Query is not supported yet for the refresh, but it's a huge step forward for those data models that use local excel worksheets or tables as data sources. Aug 24, 2021 · Chris Webb
	• Local functions in advanced scripting with Tabular Editor If you write C# and create Tabular models, you must use local functions in your Tabular Editor scripts. Automating parts of the Tabular modeling experience is getting better and better by using these techniques. Oct 24, 2021 · Sergio Murru
	• Calculation groups supported in DAX script Starting with Tabular Editor 3.15 calculation groups are supported in DAX Scripts. We can have a textual version of all the calculation items' definitions, including DAX expressions and format strings. Nov 4, 2021 · Tabular Editor