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:
- Are there any limitation for the number of filters and also the values we can pass-on from the front-end to PowerBI?
- How many filters can we apply within PowerbI? Any limitation within that?
- 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?
- 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!
