Forum Discussion
Helper IAdd parameter to Fabric report
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?
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:
- Open your report in edit mode
- Go to the Filters pane
- Use the “Add filter” option to apply filters at the visual, page, or report level
- 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 LearnLet 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
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
-
You can create a new Semantic Model from the Reporting tab by clicking on “New Semantic Model”.
-
Once the Semantic Model is created, open it and you’ll have the option to define parameters.
-
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.
-
6 Replies
- suparnababu8
Super User
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! - burakkaragoz
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:
- Open your report in edit mode
- Go to the Filters pane
- Use the “Add filter” option to apply filters at the visual, page, or report level
- 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 LearnLet 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-msftCommunity Support
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
-
You can create a new Semantic Model from the Reporting tab by clicking on “New Semantic Model”.
-
Once the Semantic Model is created, open it and you’ll have the option to define parameters.
-
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.
-
- 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
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 wanted to check if the responses provided were helpful. If further assistance is needed, please reach out.
Thank you.
