PowerBI Meta Data

[Sivakumar_ramar]

Dear Community

It will be great to include or facilitate to inclusion of the Meta Data Table population automatically of the corresponding PBI Dataset. When we create the PBI dataset,

In addition, writeback to meta data function that needs to be facilitated with PowerBI would be great.

Currently, we manually update the object description in PBI dataset, but if we want to view the definitions, we have the option to use DAX Studio of DMV Queries.

We found a way using the DMV queries.

Step 1: Get me the Workspace id

Step 2: Get me the Published PBI Dataset name

Step 3: Open a PBI report , Go to Adv Query and type

AnalysisServices.Database("Workspace Name", "PBI Dataset Name", [Query="Select * from $SYSTEM.DBSCHEMA_CATALOGS ", Implementation="2.0"])

Step 4 : Close PQ Query, we will get the table populated in PQ (Powerquery)

Step 5: Using the catalog table, we are able to build the Meta Data for Power Query (which has all the required data)

We have used the above approaches for the requirement. Prior to that, we manually go each time and query DMV tables (it is time-consuming, but with above approach)

Even though we recently got DMV queries, they now execute in PowerBI, as DAX may not be as flexible.