Share via

Application of RLS in SSAS does not work in Power BI

Nelson Alexandre da Silva Pereira 1 Reputation point
2020-10-02T19:11:40.163+00:00

When I apply RLS to a dimension in SSAS, hiding a particular column, in Power BI, the table I have with that column, simply disappears.
In this power BI table, I have columns of various dimensions, what I want is for the table to be visible and for only the column that I hid in SSAS using RAL to be hidden.
Does anyone know how to do this?

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,263 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,821 Reputation points
    2020-10-05T01:58:17.09+00:00

    Hi,

    Not sure how have implement the RLS in SSAS, was it working ?

    Follow this steps in SSAS tabular , make sure first everything works as expected in SSAS first.
    Implement row-level security in an Analysis Services tabular model

    As for the power BI part, we are not very sure about that. You could seek help as Power BI forum.

    Regards,
    Lukas

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.