Metadata report pages

With the enhanced DMV data loaded, report pages can be created, visualizing the most important columns. In the following screenshot, the table and column names retrieved via the M query joins in the previous section, Integrating and enhancing the DMV data, are included in a simple table visual:

Metadata report page

In the slicer visual on the left, the table is filtered to only display relationships in which the Internet Sales and Product tables are on the From Table side of the relationship. In other words, only the relationships in which the Internet Sales and Product tables are on the many side of a one-to-many relationship are displayed. The Active Flag column identifies the two inactive date relationships based on Due Date and Ship Date. Additionally, the cross-filtering behavior column and slicer makes it easy to identify any relationships with bidirectional cross-filtering enabled.

A Power BI Desktop file containing the M queries and report pages from this example is included with the code bundle for this book. Additionally, Chapter 2Connecting to Sources and Transforming Data with M, and Chapter 3Designing Import and DirectQuery Data Models, describe the essential concepts of M queries and relationships contained in this section, respectively.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.145.87.161