Paul Holmes on 31 Mar 2023 10:17:48
We have models used by a number of separate reports.
The modeller can have a legitimate reason to rename a measure, or to move it to another table in the model - whilst wanting all consuming reports to continue working, and potentially adopt the new measure name.
This would entail the report referencing the measure or attribute by Id.
The report developer could be offered the following options. This could be global option, or a per measure/field choice:
"Remote Model Measure Name Changes:
- Accept Automatically
- Notify Me
- Ignore
"
There may also be UI/warning considerations for the modeller, when they want move or rename a measure/field.
To support this, data lineage views in the power BI service could be enhanced to offer a lower level of detail: Field/measure lineage.
- Comments (1)
RE: Report to Remote Model: Bind measures and fields by Id not Name.
(To clarify - the Id binding I am suggesting here is in the underlying PBIX data structure. The report developer still sees the remote model's fields and measures by name, and has no need to be aware of specific Ids).