Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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:
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!
Solved! Go to Solution.
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:
#4, It obviously will cause the performance issue when you try to send large amount filter values,
Regards,
Xiaoxin Sheng
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:
#4, It obviously will cause the performance issue when you try to send large amount filter values,
Regards,
Xiaoxin Sheng
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
4 | |
3 | |
3 | |
3 | |
3 |