Share via

restrict access for a given user

ys-5108 40 Reputation points
2023-08-10T08:59:21.6266667+00:00

I use SQL Server Analysis Services and Power BI, and I need to restrict access for a given user.

I would like to ask how to achieve this? Is there any documentation for me to refer to?

Thanks in advance!

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,344 questions
Accepted answer
  1. Anonymous
    2023-08-11T02:12:59.13+00:00
    1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Amira Bedhiafi 33,631 Reputation points Volunteer Moderator
    2023-08-10T09:49:31.5966667+00:00

    1. SQL Server Analysis Services (SSAS)

    a. Implementing Role-Based Security

    You can restrict access by creating roles and assigning permissions to users within those roles.

    1. Open SQL Server Management Studio (SSMS).
    2. Connect to the SSAS instance.
    3. Select the database where you want to restrict access.
    4. Right-click on Roles and select New Role.
    5. Name the role and add a description if you wish.
    6. Go to the Membership tab and add the user you want to restrict.
    7. Go to the Cubes tab to assign read/write permissions as required.
    8. Click OK to create the role.

    You can also manage data-level security by defining Dimension Data security on the Dimensions tab.

    b. Relevant Documentation

    The official Microsoft documentation for implementing security in SSAS is a great place to start:

    2. Power BI

    In Power BI, you can control access at different levels such as dataset, report, or workspace.

    a. Row-Level Security (RLS)

    Row-level security allows you to restrict data access at the row level based on filters.

    1. In Power BI Desktop, go to the Modeling tab.
    2. Click on 'Manage Roles'.
    3. Create roles and define DAX filters as per the required restrictions.
    4. Publish the report to Power BI Service.
    5. Assign roles to specific users in the Power BI Service.

    b. Workspace Access Management

    You can also manage access by controlling permissions at the workspace level.

    1. Go to the Power BI Service.
    2. Navigate to the specific workspace.
    3. Click on 'Access' and manage users' permissions.

    c. Relevant Documentation

    You can refer to the following links for detailed documentation:

    1 person found this answer helpful.
  2. ys-5108 40 Reputation points
    2023-08-13T00:54:56.37+00:00

    Thanks all!

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.