Get lineage id of a measure from thin pbix file

70 Views Asked by At

Is there a way in PowerQuery to extract measure lineage id from a thin pbix report connected to dataset through live connection mode? I access the contents of thin pbix by unzipping it and reading the section Report/Layout.

Lineage id can be found in the DMV of dataset in a column LineageTag

select * from $SYSTEM.TMSCHEMA_MEASURES

I want to find its counterpart in the thin report. The only way I can match a measure from dataset with its thin Report/Layout counterpart is by measure name.

Edit. The purpose of my question. Suppose we want to create a table with a display name of a measure (comes from thin report) and a DAX expression of the same measure (comes from dataset).

0

There are 0 best solutions below