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.
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