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 month 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
Ability to change the hover text on the new List filter
It would nice to be able to change the hover / tooltip text on the new List filter (preview) visual. For example, currently if you have more items selected than can fit in the available space it say...EHA_SD2 hours agoAdvocate IVNew4Views0likes0CommentsDisplay the associated Power Automate flow in Power BI
When using a Power Automate visual in Power BI, it is not easy to identify which flow is currently associated with the button. Expected improvement: Display directly in the visual properties: Flo...Olivier-R352 hours agoNew MemberNew3Views0likes0CommentsAdd a built-in “Allow Direct Manager Access” option for RLS
Hello, Please consider adding a built-in RLS option in Power BI / Fabric to allow direct manager access based on the existing organizational hierarchy in Microsoft Entra ID / Azure AD. This is a ve...Haroldhngn2 hours agoAdvocate INew3Views0likes0CommentsPower BI Subscriptions: Allow a Generic Power BI Sender Instead of the Subscription Owner
With the recent changes to Power BI subscription emails, subscription notifications can appear to recipients as though they were sent directly by the person who created or owns the subscription. For...annstruchen3 hours agoNew MemberNew26Views7likes1CommentCentrally govern and restrict destructive Fabric API and MCP operations
Idea description Problem Fabric increasingly supports automated and agent-based administration through REST APIs, Fabric CLI, MCP tools, and AI agents. However, organizations need a centrally enfo...fb2003 hours agoHelper INew4Views0likes0Comments