
上QQ阅读APP看书,第一时间看更新
How to do it...
- Open a new Power BI Desktop file (PBIX) and create a blank Query.
- 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
- Click on Close and Apply from the Query Editor.
- The 785+ rows from the M library are now loaded to the data model.
- Create a Report Page Visual that uses the Function Group column for filtering.

Figure 159: Report Page of M Standard Library