Prompt for parameter value when report is opened?

[sasdfasdfsad]

Is there anyway to make PowerBI prompt for a parameter value at "runtime" similar to how SSRS has parameters you populate before a report runs?

What I want to do is let a user enter an account ID.

Then it will use that as a parameter and query folding against a view that spits out data about a specific account.

I can do cross report drill throughs by having a user right click on an account ID in a grid and drill through, BUT.... is there a way to get PBI to prompt for the account ID when the page first loads?

If a user goes directly to the Account ID Details report it loads ALL the account IDs in the view.

We want to have the user just specify a single one at load.

[lbendlin]

You are describing the functionality of a Power BI Template. (.pbit)

[sasdfasdfsad]

Is there anyway to have the user enter a text value and then have the report load data?

Basically I don't want a report to load all data in a data grid until AFTER the user has made their selection.

Like how SSRS works?

[lbendlin]

yes, that's what PBITs are - empty shells. No data until the user made their choices.

[johnpjustus]

Is there any demo video or instructions on parameterized report?

[lbendlin · Accepted solution]

Create and use report templates in Power BI Desktop - Power BI | Microsoft Learn

[johnpjustus]

Thank you!!