Because Excel for MacOS isn't supported, connecting to Power BI datasets using Power Query isn't possible. Only csv, json, and a few additional file types are supported by Power Query for MacOS Excel. There is no Power Pivot for MacOS.
This premium option allows you to connect to OLAP sources such as SQL Server Tabular, but only for On-premise SSAS or Azure Analysis Service. If you have Power BI Premium, you might be able to connect to the dataset's xmla endpoint using the CDATA plugin.
The other method is to use PBI Desktop on Windows to develop the filtered data model, deploy it to the service, and then grant them access to the Power BI Service.