Hello all,
I am working on developing a Power BI embed-for-customers/app-owns-data solution using the new TMDL .pbip format, Azure DevOps, and Fabric Git integration to move our code across our internal development, test, and production workspaces.
For security, it is necessary to publish a copy of a dataset from the internal production workspace out to multiple customer workspaces and set unique parameters. The initial deployment and creation of the datasets is fine, but I am stuck on how to broadcast out metadata changes (e.g. adding a new column, new translation, etc.) to all customer workspaces without dropping and recreating the datasets in those workspaces after the initial deployment.
The most promising options appear to be using some combination of the REST API, Power BI Deployment Pipelines, XMLA endpoints, and/or pbi-tools. However, none of these solutions seem to scale well into the hundreds or thousands of workspaces.
As much as I would love to use a Power BI deployment pipeline because of how flawlessly it works moving across 2-3 workspaces, the fact that a workspace can only be a member of one Power BI deployment pipeline in the current implemnentation is a huge limitation.
Does anyone have any advice or best practice suggestions on how to broadcast dataset updates at scale, or is there no better solution than to drop and recreate the datasets with new IDs, incur a brief service disruption, and have our application handle the updated dataset ID?
