Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper II
Helper II

Prompt for parameter value when report is opened?

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.

Super User
Super User

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

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?



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

Is there any demo video or instructions on parameterized report?

Thank you!!

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors