Forum Discussion
On Premises Data Gateway - Options for Authenticating To Analysis Services Data Source
rhardy,
You can use map user name feature to map end users with Power user, this way, as long as the end users don't know the account and password of the power user, then end users will not be able to access the SSAS data source, meanwhile, end users are able to view reports in Power BI Service
Regards,
Lydia
rhardy,
You can use map user name feature to map end users with Power user, this way, as long as the end users don't know the account and password of the power user, then end users will not be able to access the SSAS data source, meanwhile, end users are able to view reports in Power BI Service
Regards,
Lydia
What about in the case of doing row level security? For instance if I change the mapping of the user running the report to a service account (same idea as presented on your post to a power user) on our domain that has access to the cube in a certain role that has Dynamic RLS logic. The system will not recognize the user running the report, just the service account. A thought that I had, was hoping that I could pass in the CustomData field which would pass in the user running the report, just like we can on SSRS. But since I put a rule on the Effective user name to map the user to a power user or service account, I can't select CustomData so that it will send that information over in the connection string. Thoughts?