Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!!