Microsoft Power BI Cookbook
上QQ阅读APP看书,第一时间看更新

How to do it...

  1. Open a new Power BI Desktop file (PBIX) and create a blank Query.
  2. Enter the following M code in the Advanced Editor:
Figure 157: M Expression to Retrieve a Table of the M Library
  • The Query Editor should look like the following screenshot:
Figure 158: Query Editor View of Library Table Function
  1. Click on Close and Apply from the Query Editor.
  2. The 785+ rows from the M library are now loaded to the data model.
  3. Create a Report Page Visual that uses the Function Group column for filtering.
Figure 159: Report Page of M Standard Library