Power BI serves analysts today with industry-leading data preparation capabilities using Power Query in Power BI Desktop.

With the addition with Power BI dataflows, this great tool now adds self-service data preparation capabilities into the Power BI online service, and significantly expanding the capabilities

In this Guy in a Cube video, Patrick looks at a small feature called slicer restatement in Power BI. This feature will help you to determine what was selected in a slicer. While this feature was added back in April 2018, most folks don’t know about slicer restatement.

Christian Wade joins Scott Hanselman to show you how to unlock petabyte-scale datasets in Azure with a way that was not previously possible. Learn how to use the aggregations feature in Power BI to enable interactive analysis over big data.

For more information:

 

The Power BI team has a big release for the Power BI Desktop team. The most exciting feature this month is a preview of Composite models.

This feature lets you seamlessly extend your DirectQuery models with other DirectQuery sources or even imported data. We have heard from many of you, especially those in larger enterprises, that this is an essential feature and are glad to share it with all of you. We also have many reporting features this month, including an update to our visual header that lets you not only put visual all the way to the top of your canvas, but also have extensive control over the functionality and formatting of the header. NOTE: There is a minor correction for this video. Under the data connectivity section, for the Web By Example connector, it should have been Html.Table not Web.BroswerContents.

In this video, Patrick from Guy in a Cube looks at Power BI Row-Level Security And where to filter.

He found that, after applying dynamic security, customers showed up in a slicer when they should not have. Challenge accepted! He walks through Power BI Desktop to show how he fixed his Row-Level Security problem.