Forum Discussion
Embedded Power BI WORKSPACE - Filter the data using dynamic filtering column list box from website
Hi ,
I have an workspace with 5 reports which uses the same dataset having 20 + columns . It has customer name column values like X,Y,Z . Now I have the customer name column as a listbox in the website portal . I need to embed the workspace in the website portal and the data in the workspace in all the reports must work based on the filter provided in the list box from the portal . How can I achieve this ?
please provide me the step by step procedure. Thanks!!
Hi PradeepSpowerbi ,
Thank you for reaching out to Microsoft Fabric Community.
You can’t embed a whole workspace, only reports. Since all 5 reports share the same dataset, the way to do this is:
Embed each report on your site.Capture the customer selection from your list box.Use the Power BI JavaScript SDK to send a BasicFilter on Customer Name to each embedded report (report.setFilters([filter])).That way, all reports update together based on the website filter.
Here are few Microsoft Documentations for your Reference:
Embed Content in Your Power BI Embedded Analytics Application for Your Organization - Power BI | Microsoft Learn
Use filters in a Power BI embedded analytics report | Microsoft Learn
Power BI embedded analytics Client APIs | Microsoft LearnAnother option you can do is to create low level security so that when each customer logs in they will only see their data applicable to them. This is something I would highly recommend because filters are not secure. There is possibly a case where a user could override the filter and then see all the other customers data, but using row level security it is secure. Here is how to configure Row Level Security: Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn
5 Replies
Hi PradeepSpowerbi ,
Thank you for reaching out to Microsoft Fabric Community.
You can’t embed a whole workspace, only reports. Since all 5 reports share the same dataset, the way to do this is:
Embed each report on your site.Capture the customer selection from your list box.Use the Power BI JavaScript SDK to send a BasicFilter on Customer Name to each embedded report (report.setFilters([filter])).That way, all reports update together based on the website filter.
Here are few Microsoft Documentations for your Reference:
Embed Content in Your Power BI Embedded Analytics Application for Your Organization - Power BI | Microsoft Learn
Use filters in a Power BI embedded analytics report | Microsoft Learn
Power BI embedded analytics Client APIs | Microsoft LearnAnother option you can do is to create low level security so that when each customer logs in they will only see their data applicable to them. This is something I would highly recommend because filters are not secure. There is possibly a case where a user could override the filter and then see all the other customers data, but using row level security it is secure. Here is how to configure Row Level Security: Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn
Hi PradeepSpowerbi ,
Thank you GilbertQ for the prompt response.
I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.
Thank you.
Hi PradeepSpowerbi ,
May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.
Thank you.
Hi PradeepSpowerbi ,
I hope the information provided is helpful.I wanted to check whether you were able to resolve the issue with the provided solutions.Please let us know if you need any further assistance.
Thank you.