Let’s talk about the most important dimension table in the Power BI model – the Date table. A Date table includes all the attributes that you may want to filter, slice, and dice your data with to get significant insights. With a Date table, a date field anywhere within your data model won’t be a problem. 

If you are wondering when to use USERNAME() and USERPRINCIPALNAME() in RLS  for Power BI Embedded scenarios, then you are on the right blog.

Learn how to use the Tabular Editor to perform advanced data modeling techniques not available when working with Power BI Desktop. Michael Kovolsky will introduce the Best Practice Analyzer and discuss how to use this powerful tool to scan your Power BI data model to find areas for improvement.

A calendar layout – the same format used from old-style desk planners wall hangers to Outlook – could solve some of the shortcomings of the standard visuals. Not only will we be able to look back in the past, we can even use it to look into the future for schedules, forecasting, etc.

Scenario:

In Power BI Desktop, when we connect to a .json file, power query editor will transform it automatically if its structure is single.