User to Pass Parameter To Filter Report

Hi  Arranafc19 ,

To my knowledge this is not possible when you use parameters to filter out the dataset users need to have acces to the data in order to run the query, if your users are only visualizing your reports they are not abble to run the query behind and getting the information as you need.

As you describe in your scenario since you need users only to see their data the option would be RLS.

However since this is not an option what you can do is to create a password within the PBI file for each user and link that to the information they need.

This idea comes from the post below and may need adjustments from your part but check the post where I had this workaround idea.

https://www.linkedin.com/pulse/adding-password-box-power-bi-report-wyn-hopkins/

If you need any assistance to get this working please send out some mockupdata.