Application of RLS in SSAS does not work in Power BI

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,237 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,816 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.