albert on 25 Nov 2018 10:56:12
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.
- Comments (9)
RE: Allow Parameters to be saved in Dataflows
Must required feature. By passing dynamic parameter can solve many many unsupported functions by ourselves.
RE: Allow Parameters to be saved in Dataflows
A simple hack we use is to store our parameters in SharePoint excel/csv. Then load and filter as necessary. Would be nice to see this supported natively though.
RE: Allow Parameters to be saved in Dataflows
Suggestion:- Add parameters in to Data flow settings to allow you to edit them and not have to edit the json file before loading
RE: Allow Parameters to be saved in Dataflows
Yes they can (since November 2019) However ( unless i am wrong) they can't be used in a Query unless you have a Premium contract
RE: Allow Parameters to be saved in Dataflows
We want to be able to allow the user to select the date range of data they want to have ingested through Data Flows otherwise the whole table gets pulled in, which can be a lot of records. Please ad a way to add a parameter to dataflows ASAP
RE: Allow Parameters to be saved in Dataflows
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.
RE: Allow Parameters to be saved in Dataflows
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.
RE: Allow Parameters to be saved in Dataflows
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.
RE: Allow Parameters to be saved in Dataflows
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.