NEW ARTICLE
This article describes how to enable the Single Value slicer option in Power BI by adding additional metadata to the model with Tabular Editor.
Read more
 

UPCOMING LIVE
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

 

SQLBI YOUTUBE CHANNEL
Latest videos
Creating real time dashboards in Power BI with push datasets
28:52#articleAlberto Ferrari
IF
02:41#daxguideAlberto Ferrari
SWITCH
04:18#daxguideAlberto Ferrari
COALESCE
02:01#daxguideAlberto Ferrari

 


BI-WEEKLY NEWS DIGEST
Latest news
• 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