cancel
Showing results for 
Search instead for 
Did you mean: 
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
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.