Input filters on Published version

[priyankaduggal]

• @GuyInACube @I need to publish a Power BI report with input fields e.g Date and PortfolioId. These input fields should be passed to the query and give filtered dataset. Since the dataset will be huge with 36000000 records nearly if I get all the data into power bi dataset and then slice and filter,I want it to behave the same way we do in any other form. E.g. .Net.

TIA

[Greg_Deckler]

Do Dataflows support Query parameters? Is that what you are looking for, query parameters?

Are we talking Direct Query because that's kind of how it works natively.

36M rows is pretty tiny in the grand scheme of things, Microsoft demos trillion row datasets with Power BI. Use aggregation tables.

[priyankaduggal]

I need to provide input values via published version.ie user should be able to provide values in input fields.

Queryparameters will work on desktop version

[v-eachen-msft · Accepted solution]

Hi @priyankaduggal ,

---

Queryparameters will work on desktop version

---

Query parameters will also work on service. Here is the document for your reference. You could condigure it in dataset settings.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-parameters

For more details, here is also a useful blog :

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/