Passing parameters

[ashmozzart]

Hi can we pass parameters to power bi from an external data ?

[v-yulgu-msft]

Hi @ashmozzart,

There are three options to specify values for parameter: Any, List, Query.

To get parameter values from externa data, you can choose Query. Query list is a list of values created in the blank query using M Language. It is basically the ordered list of values and defined using comma separated values with any data type enclosed in braces. Alternatively, you can get a list from a column in a table which is returned by a query from external data source. To do that,  you need to click on the column to select it and then right-click and select Drill Down or Add as New Query. Then, in the drop down list of Query textbox, you can select that query you have created.

For more details, please refer to: Data-Driven Power BI Desktop Parameters Using List Queries.

Thanks,
Yuliana Gu

[th3h0bb5]

I don't think there is much functionality for this yet. You can up-vote the idea to make this a part of Power BI here. It's in the 'Planned' phase right now, but no idea on the timeframe that Roadmap has.

If you're code savvy, you might try this fix from StackOverflow.