Power BI for operational purpose

Hi andi2333,

Firstly, Power BI is not a database, it is a data visualization and analysis tool. It could connect to different data source but it is read only application. We couldn't change the data source by Power BI.

May I ask if you are trying to filter the data after connecting to it via Power BI and then distribute the filtered result data to other users.

As far as I know, you can try to create a table visual, then use slicer or filter to filter your table visual, and finally EXPORT the result and distribute it to other users. This is the more primitive method.

For reference: Export data from a Power BI visualization - Power BI | Microsoft Learn

Or you can try RLS in Power BI. Row-level security (RLS) with Power BI can be used to restrict data access for given users. 

Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn

Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.