Essentially, the idea is to have a place to add extended metadata properties on any Fabric item (and possibly even workspaces).
The particular use case that I wanted to address was to have a place to record the results of periodic "fitness for purpose" reviews of reports and infrastructure. These would permit us to focus our resource towards items that needed it most. To do so, we would like a place to record not only the result of the review (e.g. RAG status) but also the timestamp of the review.
In SQL Server land I generally would have turned to extended properties to do this but there seems to be no comparable structure in Fabric.
Tags aren't flexible enough, being only text. They're also too visible for this sort of administrative need.
Endorsement is a little closer to what we are trying to achieve, but cannot be customised, and there is nowhere to associate a datetime. Seems a bit optimistic to expect that an endorsement wouldn't degrade over time as the business changes.
I would ideally like something much more general purpose:
- Completely customisable key-value pairs
- Supporting all the usual data types
- Ability to choose visibililty of these
I think there would be a lot of other use cases that could benefit from this, aside from the one I have specified above. And it honestly could simply replace tags and endorsement.
lbendlin
on:
Fabric Copy Activity Upsert Needs Native Audit Col...
on:
Power BI Subscriptions enhancements sorely needed
on:
Ragged Hierarchy Display options in Matrix Visual
miguel
on:
Personalized Source List in Get Data