Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Using model's metadata to create table

Hi all   One of the things that we thing will make life easier for our users is if we have a report page that says what measures are in the model and gives a brief description. Helpfully, Power BI ...
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks all for the responses so far, but I've had limited success. amitchandak  and Fowmy , your links seem to be designed for a one-off exercise and rely out output files. MFelix , your link got me further in that I was able to generate a table of measure directly in the Power BI report, but it relied of the PID of the open file, which changes:

 

 

let
    Source = OleDb.Query("Provider=MSOLAP.8;Data Source=localhost:52697;Update Isolation Level=2", "SELECT * FROM $SYSTEM.MDSCHEMA_MEASURES")
in
    Source

 

 

What I erally need is:

  1. a report in the Power BI service (app.powerbi.com)
  2. that is able to generate a table containing measure metadata
  3. which can then be reported to users in the form of a table visualisation.