Power Query Parameter create/use when connecting to a dataflow
Hi ben_holmes!
Thank you for sharing your feedback. Just to confirm, and to generalize the ask a bit more, would you say that your concrete feature ask is to be able to parameterize the selections when in a navigation screen?
You can definitely use any of the solution architectures mentioned below:
CI/CD and ALM solution architectures for Dataflow Gen2 - Microsoft Fabric | Microsoft Learn
Some of them just inherently deal with CICD without you having to do any code rewrite or selecting any parameters or variables such as the Relative Reference. Perhaps adding relative references to the Dataflow connector would be enough for your case?
Thanks for responding.
For more context we have a gen 2 dataflow that many organisation power bi semantic models use. That dataflow sits in a workspace with a full deployment pipeline. In general when I start a semantic model build I start building on the PROD version of the dataflow. But there are many occasions when I need to switch to the dataflow in the test environment. Therefore, I want to publish my semantic model in a different deployment pipeline with parameter rules setup so that I can switch to test in the dev or test environment.
I think I would like to see an option in the get data process for a semantic model to setup parameters for Workspace and Dataflow ID. I would imagine this could be reduced to a tick box which auto generates the parameter in power query and amends the actual data query to use this parameter instead of a hardcoded ID.
I am not sure what you mean by navigation screen so I hope adding details on our use case makes sense.
Many Thanks
Ben Holmes
Recent ideas
Zoom Based Visibility for Location Labels in the Azure Maps Visual
Location labels can be helpful for maps but also create a lot of clutter when zoomed out. It would be great if zoom based visibility controls could be enabled for this feature.AllianceDA2 hours agoAdvocate IINew6Views0likes0CommentsNeed an option to save PBIP files without data (the .abf files)
We need an option to save the PBIP without saving the ABF file, just like the PBIT file is saved without data. As it is now, we will violate company security policies that don't allow storing data ...heve6 hours agoNew MemberNew613Views39likes6CommentsiOS Shortcuts Support for Direct Access to Power BI Reports
We are looking to deploy several Power BI reports to support emergency response activities. The intended users are primarily non-technical staff who do not use Power BI currently, but who would benef...Default81298 hours agoFrequent VisitorNew3Views0likes0CommentsSupport Fabric Workspace Identity for custom APIs
Currently, Fabric Workspace Identity cannot be used to authenticate against custom APIs protected by Microsoft Entra ID. Azure Managed Identities support requesting an access token for a specific AP...frithjof_v12 hours agoCommunity ChampionNew64Views5likes0CommentsAllow the target pipeline reference in Invoke Pipeline / ExecutePipeline to be set dynamically
Problem Today, the Invoke Pipeline activity (and legacy ExecutePipeline) requires picking the target pipeline statically at design time — a fixed Workspace/Pipeline selection in the UI, which serial...JONATHANHAUN1 day agoNew MemberNew9Views0likes0Comments