power bi desktop (sql server reporting services) tech preview

[danalerner]

Hi,

I have two questions about the latest tech preview:

1. can I pass parameters trough url?

2. can I manage permissions to data by user? I want each user viewing in SSRS to his data related to him and his subordinates?

thanks,

Dana

[luisrh]

see below for answers:

1. can I pass parameters trough url?

2. can I manage permissions to data by user? I want each user viewing in SSRS to his data related to him and his subordinates?

 for OLAP cubes and tabular models,  the best way to manage this is to leverage the @ Username function in the datasource -  when the PBI report runs within the context of SSRS,  there is user context -so when a user runs the report - if you modify the connection string to use the UserName() function and set CustomData with that value on the datasource's connectionstring -, you can use DAX filtering to implement RLS (row level security) - see this for details on how to do this on a tabular model  - https://blogs.msdn.microsoft.com/himanshu1/2013/03/01/implementing-dynamic-security-in-tabular-model...

[v-caliao-msft · Accepted solution]

Hi @danalerner,

1. can I pass parameters trough url?

Currently, Power BI desktop (SQL Server Reporting Services) can only publish the reports which connect to SSAS database by using Connect Live mode to report server. And we cannot use parameters in connect live mode.

2. can I manage permissions to data by user? I want each user viewing in SSRS to his data related to him and his subordinates?

We can create differenet folder for different users, and move power BI report to corresponding folders, and set permisssion for those different folders.

Regards,

Charlie Liao