Forum Discussion
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.
6 Replies
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.
