How to do it...

  1. Create a new Power BI Desktop file (.pbix).
  2. Create a Query using DirectQuery Data Connectivity mode.
    • Click on Get Data and choose SQL Server database.
  1. Select a view to be used by the model via the navigator.
Figure 23: Creating a DirectQuery Data Source
  1. Duplicate the initial query and revise the Item value of the Navigation step to reference an additional view supporting the model:
Figure 24: Referencing views from the Formula Bar
  1. Repeat step 3 until all the dimensions and facts are being accessed by their associated ...

Get Microsoft Power BI Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial