Add parameter to Fabric report

[coolie]

I've just created a report (from Reporting tab in SQL Endpoint) and need to add a filter parameter. Online search just tells me to use PBIRB do I have to use this or can it be added via the web app?

[burakkaragoz · Accepted solution]

Hi @coolie ,

If you're working from the Reporting tab in the SQL Endpoint and want to add a filter parameter to your Fabric report, you don’t necessarily need PBIRB unless you're automating or deploying via CLI.

Here's a quick way to do it via the web app:

1. Open your report in edit mode
2. Go to the Filters pane
3. Use the “Add filter” option to apply filters at the visual, page, or report level
4. If you want to simulate a parameter, you can use a slicer or create a calculated table that acts like a parameter input

If you're looking for dynamic filtering via URL parameters, that’s not fully supported yet in Fabric reports like in classic Power BI, but it’s on the roadmap.

📘For more advanced parameterization (like PBIRB or deployment pipelines), check this doc:
Microsoft Learn 

Let me know what kind of parameter you’re trying to add (e.g. user input, dynamic filter, etc.) — I can help you set it up the right way.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

Translation and text editing supported by AI

[v-veshwara-msft]

Hi @coolie ,
Just wanted to check if the responses provided were helpful. If further assistance is needed, please reach out.
Thank you.

[v-veshwara-msft]

Hi @coolie ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.

[v-veshwara-msft]

Hi @coolie ,

Just checking in to see if you query is resolved and if any responses were helpful.
Otherwise, feel free to reach out for further assistance.

Thank you.

[v-veshwara-msft · Accepted solution]

Hi @coolie ,
Thanks for posting in Microsoft Fabric Community.

In addition to suggestions by @burakkaragoz ,

If you're working with Direct Lake datasets, from the SQL Endpoint's Reporting tab in Fabric

1. You can create a new Semantic Model from the Reporting tab by clicking on “New Semantic Model”.

2. Once the Semantic Model is created, open it and you’ll have the option to define parameters.

3. Then go to File > Create a New Report from within the Semantic Model, and you can build a report that uses the parameters.

Alternatively, you can connect to it using Power BI Desktop (live connection) and define parameters locally there.

Similar discussion: Solved: Re: Adding field parameters in Fabric Lakehouse Se... - Microsoft Fabric Community

Another approach is to use a notebook in Fabric with the sempy library to programmatically add field parameters to the Semantic Model.

For more details, please visit this link: Re: How to create field parameters in Power BI Dir... - Microsoft Fabric Community

Hope this helps. Please reach out for further assistance.

Thank you.

[burakkaragoz · Accepted solution]

Hi @coolie ,

If you're working from the Reporting tab in the SQL Endpoint and want to add a filter parameter to your Fabric report, you don’t necessarily need PBIRB unless you're automating or deploying via CLI.

Here's a quick way to do it via the web app:

1. Open your report in edit mode
2. Go to the Filters pane
3. Use the “Add filter” option to apply filters at the visual, page, or report level
4. If you want to simulate a parameter, you can use a slicer or create a calculated table that acts like a parameter input

If you're looking for dynamic filtering via URL parameters, that’s not fully supported yet in Fabric reports like in classic Power BI, but it’s on the roadmap.

📘For more advanced parameterization (like PBIRB or deployment pipelines), check this doc:
Microsoft Learn 

Let me know what kind of parameter you’re trying to add (e.g. user input, dynamic filter, etc.) — I can help you set it up the right way.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

Translation and text editing supported by AI

[suparnababu8]

Hi @coolie 

need to add a filter parameter? where you need to add it? could you pls elobrate your questions in-detail?

Thanks!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!