Episode 5 – The Data Model

Recorded May 19, 2016

In this episode, we were fortunate enough to have Kasper De Jonge as our guest. Kasper is Senior Program Manager on the Analysis Services team, and has been with the tabular data model since its inception.

We covered a fair bit of ground, including topics like:
– What’s the difference between classic cubes and the new tabular model
– Why is the tabular model “everywhere” these days?
– What do the new terms mean?
– How does SharePoint and PowerPivot for SharePoint fit into the new landscape?
– Where does claims authentication fit into the picture?
– When is it, or is it not appropriate to use Power Query

And several other topics.

We invite you to check out the recording of the show for the details.

News
SQL Server 2016 Launches on June 1
Standard Edition now supports Tabular models
Power BI Storage increases to 1 GB per model
Power BI Q&A works with Enterprise Gateway data sources (tabular model only)
Working with SharePoint Lists in Power BI and OData – Marc Anderson
PBI Gateways supports UPN mapping
Drilldown has moved to the explore menu in Power BI

Tips and Tricks

Username() function in DAX only works when RLS is configured
You can’t rename fields in PBI Visuals, but you can create calculated measures and columns