Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
Solved! Go to Solution.
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!!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
32 | |
26 | |
24 | |
19 | |
16 |
User | Count |
---|---|
52 | |
38 | |
24 | |
20 | |
20 |