External Tools

Microsoft Excel Query

You can query the data and save the data in a Microsoft Excel spreadsheet.

Open a Microsoft Excel spreadsheet.
Select Data, and then select Get Data.
In the window, select Other Sources, and then select Blank Query.
A Power Query Editor window appears.
Enter your Power M query, and then select Done.

Note: Refer to the Power M query section for a sample query.
If prompted for data privacy information, select Ignore, and then select Save.
All the database families appear in the preview page.
Select the Data column of a family, then right-click and select Drill Down.
The preview data is downloaded.
Select Close & Load, and then select Close & Load.
Excel will the query the full data for an entity and download a document.
Select File, and then select Save.
The document is saved.

You can query the data using the Microsoft Power BI application.

Access the Microsoft Power BI application.
Select Home, then select Get Data , and then select Blank Query.
The Power Query Editor window appears.
Select Advance Editor, then enter the Power M query, and then select Done.

Note: Refer to the Power M query section for a sample query.
If prompted for data privacy information, select Ignore, and then select Save.
Select the Data column of a particular family, then right-click and select Drill Down.
The preview data is downloaded.
Select Close & Load, and then select Close & Load.
The Power BI window appears. You can view the property of the selected entity in the FIELDS section.
Select Charts in the Visualizations section, and then generate the charts by dragging the entity properties to the axis and value sections in the chart.
Select File, and then select Save.
The document is saved.