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?
- ben_holmes1 day agoNew Member
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
Auto-propagate Lakehouse (Direct Lake) permissions to users assigned to a Power BI App audience
Problem When a Power BI report uses a Live Connection to a Direct Lake Semantic Model, end users must have explicit ReadAll / ReadData permissions on the underlying Lakehouse (or its SQL analytics e...majofv1 hour agoNew MemberNew5Views1like0CommentsAdd a Close or “Return to previous page” button to Semantic Model Security and Settings pages
When updating RLS group assignments through Semantic model > Security, there is no consistent in-product Close or Done button that returns the user to the previous workspace view. The browser Back b...Kalaiselvan4 hours agoFrequent VisitorNew2Views0likes0Comments