Forum Discussion
Url filter on Dataset query parameters
Thank you for the suggestions, I'll have a look at these !
For now it's DirectQuery but I'll need to make this work for Live connections as well.
The parameter is set up like this :
And then i want to filter on the Id parameter in the URL http://localhost/Reports/powerbi/my-report?Id=myId
I've got custom secturity set up so if someone enters the wrong Id they won't get authenticated. So the only problem with this solution is that the report isn't filtered on Id
Helper IIFor Live Connections you do not need the parameter as SSAS cubes perform the RLS for you if you set it up in the cube and configure the report data source to connect to the cube in the security context of the user running the report.
In terms of the DirectQuery parameter, what is the data source type and how are you using the parameter value?
Okay I'll need to read up on Cubes and RLS
The parameter is used when querying the DB for data
i.e. SELECT * FROM data_table where CustomerId = Id
This query will then query the data_table, which contains data for all customers, and only return data for that CustomerId.