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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Mbalcarek
Helper I
Helper I

Power BI Embedded - 3rd party embedding - using Power BI parameters to prefilter

Hello, 

We currently display reports using Power Bi embedding. Our users do not have O365 accounts. 

We currently pre-filter data using an Embed Configuration and filtering by a column value in a table. Ref: https://github.com/Microsoft/PowerBI-JavaScript/wiki/Embed-Configuration-Details 

Is there a way to pre-filter the report using Power BI Parameters? [Edit Queries; Manage Parameters] (  ref: https://www.mssqltips.com/sqlservertip/4475/using-parameters-in-power-bi/ 

Thank you

 

What we do now:

                    var basicFilter = {
                        target: {
                            table: """ + FilterTableName + @""",
                            column: """ + FilterColumnName + @"""
                        },
                        operator: ""In"",
                        values: [
                            """ + FilterColumnValue + @"""
                        ]
                    };

1 ACCEPTED SOLUTION
Mbalcarek
Helper I
Helper I

I don’t believe this is possible.

  1. Although there is an API which allows us to get and set the parameters, it acts against the Dataset. If we have a pbix that has data for multiple projects, updating the parameter will update it for the whole data-set - and the report for all projects would be affected.

  2. The Power BI Embedded Configuration settings do not support query parameters: https://github.com/Microsoft/PowerBI-JavaScript/wiki/Embed-Configuration-Details I think it is because by the time the report is made available for display, the queries that use the parameters have already run.

Recommendation: concatenate multiple filter criteria to a single column and use the existing filtering mechanism.

View solution in original post

1 REPLY 1
Mbalcarek
Helper I
Helper I

I don’t believe this is possible.

  1. Although there is an API which allows us to get and set the parameters, it acts against the Dataset. If we have a pbix that has data for multiple projects, updating the parameter will update it for the whole data-set - and the report for all projects would be affected.

  2. The Power BI Embedded Configuration settings do not support query parameters: https://github.com/Microsoft/PowerBI-JavaScript/wiki/Embed-Configuration-Details I think it is because by the time the report is made available for display, the queries that use the parameters have already run.

Recommendation: concatenate multiple filter criteria to a single column and use the existing filtering mechanism.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.