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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
saurabh_2020
New Member

Passing Filters from Web UI to the embedded PowerBI Report

Hello PBI Experts, 

 

My team is working on developing a front-end Web application UI with embedded PowerBI reports. We are providing 5 global filters for the user on front end. The user can filter the reports from the filters in the front end, which gets passed on to the powerBI from backend. 

Problem: The client has asked to add 3 more global filters with one specific filter, denoting store_id,  having around 3000 values. it will be great if you could help me to know the following:

  1. Are there any limitation for the number of filters and also the values we can pass-on from the front-end to PowerBI?
  2. How many filters can we apply within PowerbI? Any limitation within that?
  3. For the below process used to pass-on filter from front-end to powerbi, I am not sure how the back-end process is working. So, is the powerBI using a dax query to fetch the filter details from front-end or is it that the selected filter-value combination is being directly applied in the Filter section in powerBI from front-end? 
  4. Any potential performance issue in context of loading of powerbi report if so many filters are applied? 

 

Process Used: We are embedding powerbi in react using powerbi-report-component library. The filters are passed on to PowerBI using the following code 

 

this.report.setFilters(arr).then((res,rej) => {​​​​​​​​

 

              }​​​​​​​​).catch(function (errors) {​​​​​​​​

                console.log(errors);

              }​​​​​​​​);

            }​​​​​​​​

            }​​​​​​​​


where arr captures the filtered values


Thanks!

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @saurabh_2020,

#1, AFAIK, power bi does not limit the general filter usage.

#2, I check the document but not found they mention the limits of filter usage, so I think the limit probably existed on the request content size.

#3, I'd like to suggest you take a look at the following links to know more about power bi javascript filter and configurations:

PowerBI-JavaScript / Filters 

Embed Configuration Details 

#4, It obviously will cause the performance issue when you try to send large amount filter values,

Regards,
Xiaoxin Sheng

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @saurabh_2020,

#1, AFAIK, power bi does not limit the general filter usage.

#2, I check the document but not found they mention the limits of filter usage, so I think the limit probably existed on the request content size.

#3, I'd like to suggest you take a look at the following links to know more about power bi javascript filter and configurations:

PowerBI-JavaScript / Filters 

Embed Configuration Details 

#4, It obviously will cause the performance issue when you try to send large amount filter values,

Regards,
Xiaoxin Sheng

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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