How can we improve Power BI?

Allow Parameters to be saved in Dataflows

At the moment, parameters cannot be created and saved in dataflows. Parameters are automatically converted to a table when saving the dataflow.

Parameters are useful to easily change or update specific values in SQL queries.

49 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

albert shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

4 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    The ability to "dynamicize" a Dataflow would be amazing. We do a lot of work connecting to multiple databases which share the exact same schema. Being able to define the dataflow as the source at run time would be amazing.

  • Andrew Simmans commented  ·   ·  Flag as inappropriate

    It looks as though putting "Parameters" in makes the dataflows Computed and thus they need a Premium Account which is too expensive. One of the main benefits that I use parameters for is to switch the SQL datasource from Development to Live. To have to go into each dataflow and make this change is laborious.

  • Olivier Travers commented  ·   ·  Flag as inappropriate

    Parameters can actually be saved in Dataflows, make sure to right click and uncheck Load in the online query editor. The UX will sure need to be improved though.

  • Kirsty commented  ·   ·  Flag as inappropriate

    Please! I will be handing over a Power BI solution to end users who don't know much about Power BI. They are ok with editing parameters in Service or even in the front end of Desktop. Training people to edit parameters in Dataflows is a big draw back as it risks them making a mistake with code as well.

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.