Managing Parameters in dataflows without editing the dataflow.
Like Power BI Dataset, we can't manage or change parameters of dataflows in settings windows. in order to change the parameters of dataflows we have to go to edit mode and then we are able to change it. Many a times we only want to change the parameter without editing the query.
In Power BI Dataset, It more easier to manage those in refresh settings window. It would be awesome If we get similar experience with dataflows as well.
Thanks
3 Comments
- par_adeenNew Member
Giving this my vote. Yes this it's probably something that has been missed when implementing. Because using deployment pipelines we can change parameter values...
I use parameters to limit the amount of data I have when developing (using a folded to 10)
- fbcideas_migusrNew MemberStatus added:Needs Votes
- miguel
Community Admin
Status changed:Needs VotestoCompletedRecently this year we delivered a new functionality specific to Dataflow Gen2 where you can pass parameter values to change the evaluation of the Dataflow:
Use public parameters in Dataflow Gen2 (Preview) - Microsoft Fabric | Microsoft Learn
It is purposefully a different mode for evaluating Dataflows. We also plan to support workspace variables in the future, so you would have ways to have a centralized way to define and modify your variables whilst they can be leveraged by all the Fabric items that reference them.
Recent ideas
Paste values in slicers for hierarchy data
Hierarchical slicers are widely used in enterprise reports (for example Product RCN > SKU Key, Region > Country > City, or GPP > Division > RCN > SKU). Users often need to bulk-filter by pasting valu...eddieisking200041 minutes agoFrequent VisitorNew4Views0likes0CommentsPower Query Parameter create/use when connecting to a dataflow
In power query when you connect to a table in a dataflow there are no options to create or use a parameter for that dataflow. When connecting to SQL there is an option when setting up the connection ...ben_holmes3 hours agoNew MemberNeed Clarification202Views3likes2CommentsMake Copilot Approval status for semantic model available through API
In recent versions fabric allowed to mark a semantic model as approved for copilot to reduce AI adoption friction. However there is no specific way for external governance application to analyse whi...FrançoisD3 hours agoFrequent VisitorNew9Views2likes0CommentsClone a workspace, including its data, to a new workspace
Description: Today there's no way to fully clone a Fabric workspace: git sync and Deployment Pipelines move item definitions only, not the underlying data; Warehouse's zero-copy CREATE TABLE ... AS ...gclements4 hours agoHelper IINew12Views1like0CommentsAllow NotebookUtils getSecret() to authenticate with Workspace Identity
Current behavior In Microsoft Fabric, notebookutils.credentials.getSecret() authenticates against Azure Key Vault using the identity of the user who executes the notebook. This behavior appli...tmihara10 hours agoNew MemberNew8Views0likes0Comments