Dedicated support for the following workflow should be a priority. Currently there are a bunch of hacks people are resorting to to disable entity loads. But this and my workflow should be dedicated features. It follows on, extends the hack to disable loading of a dataflow entity to use it as reference logic. e.g. a master data transformation/ETL scenario. I've recently found that you can ammend the M query in a dataflow entity to reference an entity from another dataflow via entering the workspace directly. I discovered this by testing whether the copied M query from PBI desktop of a dataflow entity could be pasted into the query editor of a different dataflow in power bi service. It seems to work. Just another deficit and hacky nature of Power BI that I find annoying.... they are still not supporting metadata management and content reuse as a first class capapbility... I think there should be a dedicated option to add a workspace and an entity from another workflow directly. So Im concerned and wouldn't be surprised if the dataflow ETL that I built today will be invalidated in the future... So by example the code in BI service in a dataflow looks like below. Once the dataflow param is set to null and the workspace connects to your workspace ID you can then navigate the various dataflows. By disabling load as others have found you can then start to maintain a core registry of logic in a stage area and resuse more widely. This is getting a lot closer to adequate re-use of code and logic. let Source = PowerBI.Dataflows(null), #"1234" = Source{[workspaceId = "1234"]}[Data], #"5678" = #"1234"{[dataflowId = "5678"]}[Data], CIRAM_STG_tblVehicle = #"95678"{[entity = "CIRAM_STG_tblVehicle"]}[Data], #"Renamed columns" = Tabl.RenameColumns(CIRAM_STG_tblVehicle, {{"fldRegistrationNo", "Rego"}}) in #"Renamed columns"
1 Comment
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Allow External OneLake Data Shares to Be Accepted into Multiple Fabric Item Types
Fabric External Data Sharing provides an excellent zero-copy mechanism for sharing OneLake data across tenants. However, the receiving tenant currently has to accept the share into a Lakehouse. I w...Mourak8 hours agoNew MemberNew5Views0likes0CommentsAllow OneLake Shortcut Authentication Mode to Be Changed In Place
OneLake shortcuts support passthrough and delegated authentication, but changing the authentication model currently requires deleting and recreating the shortcut. I would like shortcut authenticatio...Mourak8 hours agoNew MemberNew7Views0likes0CommentsTenant-Wide OneLake Shortcut Lineage and Impact Analysis
This is grounded in a documented limitation: shortcut lineage is currently workspace-scoped, and Microsoft specifically says lineage for shortcuts to warehouses and semantic models isn't currently av...Mourak8 hours agoNew MemberNew11Views0likes1CommentAdd an End-to-End Production Reference Architecture for Microsoft Fabric Real-Time Intelligence
I would like to see a complete end-to-end Microsoft Fabric Real-Time Intelligence reference architecture that demonstrates how the individual RTI capabilities work together in a production-oriented s...Mourak8 hours agoNew MemberNew4Views0likes0CommentsImprove CI/CD consistency for Microsoft Fabric Real-Time Intelligence Eventstreams
Microsoft Fabric Real-Time Intelligence has made strong progress with Git integration and deployment pipelines, but lifecycle management can still be inconsistent across Eventstream sources, destinat...Mourak8 hours agoNew MemberNew3Views0likes0Comments