Forum Discussion
Embedded Power BI WORKSPACE - Filter the data using dynamic filtering column list box from website
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
Another 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