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

Don'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.

Reply
sasdfasdfsad
Helper III
Helper III

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.

1 ACCEPTED SOLUTION
6 REPLIES 6
lbendlin
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?

 
 
 

Untitled.png

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

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.