Toanphung
1 year agoFrequent Visitor
Status:
New
Dynamic content for Connection under Semantic Model Refresh activity
Hi Fabric team,
We really need the ability to parameterize connection string / ID when using Semantic Model Refresh activity to connect to a workspace in a dynamic way.
Please consider this request and put in your future releases.
Thanks.
1 Comment
- dankalashnikovRegular VisitorI want to add strong support to this idea, but I'd also like to reframe it: this is a product bug, not just a missing feature. The behavior as it stands is incorrect for any CI/CD workflow, and it has real production risk. The problem: When a Fabric pipeline containing a Semantic Model Refresh activity is deployed from DEV to a higher environment (TEST, PROD) via Git/DevOps integration, the workspace and semantic model target baked into the activity do not remap to the target environment's equivalents. The pipeline silently continues to point at - and refresh - the DEV semantic model, even when running in a TEST or PROD workspace. There is no warning, no deployment-time error, and no indication that the connection is stale or environment-mismatched. Why this is a bug and not just a missing enhancement: Every other Fabric item type that references environment-specific resources is expected to be remapped via deployment pipelines or parameter substitution. The Semantic Model Refresh activity uniquely hard-codes its target by storing a fixed workspace ID and dataset ID at configuration time, with no mechanism for the platform to resolve the correct target after promotion. This violates the fundamental contract of Fabric's own deployment pipeline and Git integration model: that items promoted between environments should operate against resources in that environment, not the source. The consequence isn't just inconvenience - it's a correctness failure. A PROD pipeline completing "successfully" while actually refreshing a DEV model gives false confidence, leaves PROD reports stale, and can go undetected for extended periods. What the fix should look like: At minimum, the activity should support parameterization of workspaceId and datasetId (as suggested by Toanphung) so that deployment pipeline rules or variable substitution can inject the correct values per environment - consistent with how other parameterized activities behave. Note that dynamic expressions are allowed but the changes do not save when exiting the pipeline - indicating there is clearly a bug in the feature. Ideally, the platform should resolve these references relative to the workspace the pipeline is running in, not where it was originally configured, as a default behavior. A deployment-time warning or validation error when a cross-workspace reference is detected would also be a meaningful interim step. There are already a couple of known workaround in the community - using a Web activity against the Power BI REST API with workspaceId passed as a pipeline parameter or overwriting the workspaceId and datasetId in the Aure DevOps deployment pipeline but the fact that users must abandon the native activity to get correct behavior in a multi-environment setup is a clear signal that the native activity is incomplete or broken. Please prioritize this as a bug fix, not a backlog idea. Fabric's value proposition is deeply tied to enterprise-grade CI/CD and ALM. A core pipeline activity that cannot safely survive promotion between environments undermines that entirely.
Recent ideas
Slicer option to show no data when no value is selected
Hello Power BI Team, Description: Currently, when the "Select All" option is enabled in a slicer, selecting it displays all related values as expected. However, when "Select All" is de-selected and...74075431 minutes agoNew MemberNew2Views0likes0CommentsParameterize Dataflow Gen2 data source connection
Allow the Dataflow Gen2 data source connection GUID to be parameterized and stored in a Variable Library. This would allow the same Dataflow to use different connections depending on the workspace/e...frithjof_v2 hours agoCommunity ChampionNew10Views1like0CommentsAutomatically match PowerBI chart background color to Powerpoint slide background color
Export PowerBI to PowerPoint slide - Can we define the PowerBI export background color to automatically match the PowerPoint slide background color ? By Default, the PowerBI background color is Whi...jim_chan6 hours agoNew MemberNew7Views0likes0CommentsNew Card Visual - Alignment of Reference Label Values
The latest Power BI Desktop version I'm allowed to use at work currently is Version 2.154.1260.0 (May 2026), so if this request has already been implemented in later versions, please disregard. Othe...nk685f7 hours agoAdvocate INew9Views0likes0Comments