Locking the filter in power query

in the attached file suppose the dataset is in a particular folder.
When a query is creato get only the result for " Adventure works " for somone to analyze the data
from the tab query Adventure Works, this tab will be in a seperate xls file
next a similar query for another manufacturer to analyze

continue .
to analyze an other set of data again in a seperate xls file

how can I prevent that a user changes the filter setting.
the user has only access to his proper dataset and no access to onbther data

kind regards and thanks in advance


sample set .xlsx (458.1 KB)

Hi Roger,

Why not consider RLS?

Create Excel workbooks with refreshable Power BI data from the Power BI Service. Row-level security (RLS) and object-level security (OLS) are supported for both Analyze in Excel and Export with Live Connection.

I hope this is helpful

Hello @Roger

Did the responses above help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION

Thank you

Hello @Roger

We’ve noticed that no response was received from you on the post above.

Just following up if the response above help you solve your inquiry.
If it did, please mark his answer as the SOLUTION.

In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

Hi @Roger
Due to inactivity, a response on this post has been tagged as “Solution”.

If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.

We request you to kindly take time to answer the Enterprise DNA Forum User Experience Survey,.

We hope you’ll give your insights on how we can further improve the Support forum. Thanks!