Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello
I used a Semantic Model Activity with Dynamic Content for both the Workspace Id and Semantic Model. This is within a for each container as I want to loop through a number of semantic models based on the workspace passed through to it by a lookup activity.
For the Workspace Setting, it does not offer me the option to Add Dynamic Content, but if I type in @, it then shows Add Dynamic Content.
However , the Semantic Model Setting does show the Add Dynamic Content Option in the dropdown.
I added the expressions for both settings - these are being passed through from other Pipeline return values.
When I added the dynamic content, I noticed that the Settings names add ID to end of Workspace and Semantic Model. (And it is the IDs I am passing through dynamically).
I save the pipeline and everything looks OK.
I then close the pipeline and open it again. The expressions in Workspace ID and Semantic Model ID have disappeared, plus the Settings Names no longer have ID at end of Workspace and Semantic Model:
Is this a bug that needs fixing? It is a confusing experience for the end user.
In case relevant, I am working on a Capacity based in UK South Region.
Also, I note that in your documentation it states that this activity only works with Semantic Models you create yourself. Is this something that is permanent, or will this change in the future?
Is the only other option to attempt to refresh semantic models using dynamic content (based on metadata stored in database) using the Fabric API via a Web Activity?
Many thanks for your help
Kind regards...
agree with @tayloramy , this warrants a ticket.
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .
Hi @JaneLHunt,
This is fun.
I think there's a couple of things going on here.
The first is the system not showing the add dynamic content button, but then allowing you to add dynamic content when you type @. Not everything supports dynamic content, and I have a gut feeling that the @ workaround works visually, but then doesn't actually save it.
This doesn't explain why the field that does have the dynamic content button also doesn't save it however.
I feel like a ticket is in order, either you're able to do things in the UI that aren't allowed, or you're doing things that are allowed and they aren't getting saved.
In the meantime, my approach would be to use a notebook to refresh the model using the fabric APIs. Not ideal at all, but functional while Microsoft Support figures out what is happening with the refresh activity.