Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Need to Restrict the data while loading in to Power BI from SSAS Multidimensional cube

We have applied security in SSAS cube and while adding role to user in cube it's working fine. But while loading SSAS cube in to Power BI we are able to see total data . How can we restrict the data coming from cube in to Power BI.

Tips and Tricks

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Please provide more details. Do you see the issue in the Power BI service? Did you enable credentials passthrough in the gateway connection?

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    4 years ago

    Hi Anonymous ,

     

    Please make sure you are using a Live connection and check this document.

    https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-tutorial-row-level-security-onprem-ssas-tabular 

    Based on the effective user name request, Analysis Services converts the request to the actual credential after querying the local Active Directory. Once Analysis Services gets the credential, Analysis Services returns the data the user has permission to view and access.

    What you need to pay attention to is whether the user credentials for logging in to power Bi have the correct role permissions in SSAS.


    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.