Forum Discussion

jockefe's avatar
jockefe
Icon for Advocate IV rankAdvocate IV
9 years ago

Impersonate user when running report

I have set with SSAS multim cubes and PBI where I use dimensional securityin SSAS
I wonder if there are any options for impersonate users when testing the reports
I am looking for something similar to SSAS change user or effectiveusername

Second questions is if it is possible to have default selection in filters/vizuals based on the user
A user could have a default customer for example
Need Help

3 Replies

  • jockefe's avatar
    jockefe
    Icon for Advocate IV rankAdvocate IV
    9 years ago

    Any ideas?

    There is unfortunately not possible to edit the connection string (this would have made it possible to add the effetiveusername prpoerty)

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi jockefe,



    I wonder if there are any options for impersonate users when testing the reports
    I am looking for something similar to SSAS change user or effectiveusername

    Have you tried map your Power BI sign in name with a local directory UPN for your Analysis Services in this scenario? For more details about Usernames with Analysis Services in Power BI, you can refer to this article. :smileyhappy:




    Second questions is if it is possible to have default selection in filters/vizuals based on the user
    A user could have a default customer for example

    As far as I know, it is not possible to do it currently. :smileyhappy:

     

    Regards