With the server and database known, parameters and queries can be created in Power BI Desktop to stage the DMV data for further transformations. In the following screenshot from the Power Query Editor, three query groups are used to organize the parameters, the DMV queries, and the enhanced queries (Metadata Report Tables) used by the report:
As per the TablesDMV query, the two parameters (AnalysisServicesServer and AnalysisServicesDatabase) are passed to the AnalysisServices.Database() function for each DMV query. As indicated by the gray font of the DMV queries and the parameters, these queries are not loaded to the data model layer.
Given the small size of the DMV data and the limitations of SQL SELECT queries against DMV data, a simple SELECT * is used to expose all columns and rows. The Metadata Report Table queries contain all the joins and transformations to prepare the data for reporting.