topic Re: Embedded Power BI WORKSPACE - Filter the data using dynamic filtering column list box from website in Service

Embedded Power BI WORKSPACE - Filter the data using dynamic filtering column list box from website

PradeepSpowerbi — Fri, 22 Aug 2025 06:14:09 GMT

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!!

Re: Embedded Power BI WORKSPACE - Filter the data using dynamic filtering column list box from website

v-venuppu — Fri, 22 Aug 2025 12:23:31 GMT

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 Learn

Re: Embedded Power BI WORKSPACE - Filter the data using dynamic filtering column list box from website

GilbertQ — Sun, 24 Aug 2025 21:56:02 GMT

Hi PradeepSpowerbi

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

Re: Embedded Power BI WORKSPACE - Filter the data using dynamic filtering column list box from website

v-venuppu — Mon, 25 Aug 2025 07:32:33 GMT

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.

Re: Embedded Power BI WORKSPACE - Filter the data using dynamic filtering column list box from website

v-venuppu — Thu, 28 Aug 2025 08:44:45 GMT

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.

Re: Embedded Power BI WORKSPACE - Filter the data using dynamic filtering column list box from website

v-venuppu — Mon, 01 Sep 2025 06:13:45 GMT

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.