Tag Archives: Security

ByHariharan Rajendran

Monitor Power BI Services Health

It always mandatory to monitor the services that we engaged with. It helps us to understand the status of the services and some additional information.

This is very much suitable for cloud based services like Azure because those services are managed and maintained by Microsoft Azure team.

To monitor the services, you should have admin access. Let us take a scenario with office 365.

Follow the below steps to monitor the Power BI Services,

  1. Connect O365 admin center
  2. Expand Health and choose service Health. It will list out all the services. If the services are working good then you can see a green tick mark near each service name.
  3. Identify the services that are showing any advisory.
  4. Check the advisory and understand the status details.

ByHariharan Rajendran

Multi-factor Authentication for Power BI – O365

It is easy to enable the multi-factor authentication for a user. To enable, administrator permission is required. Once we enable the multi-factor authentication to the user then the user should pass through the authentication wherever that user wants to access.

For example, if you are Office 365 admin and you are enabling multi-factor authentication for a user. That user should go through the second authentication to login to email, power bi or whatever services that are connected with O365.

Follow the below steps to enable Multi-factor Authentication,

  1. Go to office 365 Admin Portal
  2. Expand users -> Active users
  3. Select the user and click multifactor authentication in more settings
  4. Select the user and click enable
  5. Go to service settings and choose the appropriate options.
  6. Connect app.powerbi.com, sign-out and sign-in again. We can choose the method of authentication, either by phone call or sms.

ByHariharan Rajendran

SSRS Security Roles

SQL Server Reporting Services has pre-defined roles for security.

Roles are,

  • Browser
  • Content Manager
  • My Reports
  • Publisher
  • Report Builder

Each role has set of access which explored below. We can customise these roles or create a new role by connecting reporting services in SQL Server Management Studio.

1