Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Power bi Report Permissions - ssas tabular

Hello Friends,

 

How do I grant "All people within my organization" Powerbi Report permissions on the SSRS Reporting Server? The reason being that the powebi Report should be viewable by any department i.e Business Analysts, HR, PM Office etc.

 

Below is my PowerBI setup scenario

  • SSRS Reporting Services 2016
  • Power BI Report Server - May 2017 Preview vNext ( On-premises Report Server). I have set this up on a different instance within the same Reporting Server.
  • Power BI Desktop comptabile with May 2017 Preview.
  • Database Engine 2016
  • SSAS Tabular Model
  • Visual Studio Data Tools 2015
  • Developed Power BI Report in PowerBI Desktop and uploaded to SSRS Instance.

 

Do I need to give Read permissions to the AD Group "NT Authority\Authenticated Users" or "<Domain>\Domain Users" for 

  1. SSAS Role ?
  2. or PowerBI Report on SSRS -> Manage - > Security -> Browser Permissions

 

Abhi

 

  • GilbertQ's avatar
    GilbertQ
    9 years ago

    hi Anonymous

     

    Can the users at least get to the SSRS report server?

     

    If they can then yes the next step is to make sure that they can indeed access the SSAS Tabular Server. Have you added the AD Groups into a Role on your SSAS model?

9 Replies

  • Hi Anonymous

     

    In my experience in the past I have given access to 'Domain\Domain Users'

    • Anonymous's avatar
      Anonymous
      Not applicable
      Hey GilbertQ

      No luck with the mentioned AD Group. Even gave a specific user explicit access. Says permission denied. Does SSAS also require read permissions for Domain Users. I believe the data source permissions to access database should be good enough.
      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User

        hi Anonymous

         

        Can the users at least get to the SSRS report server?

         

        If they can then yes the next step is to make sure that they can indeed access the SSAS Tabular Server. Have you added the AD Groups into a Role on your SSAS model?

  • aghonaim's avatar
    aghonaim
    Icon for Most Valuable Professional rankMost Valuable Professional

    Would it be possible to add all users in the domain without specifying them one by one ?

    • Anonymous's avatar
      Anonymous
      Not applicable

      Yes. Add <DOMAIN>\Domain Users in the "Security" of the PowerBI Report. After which, any user in your Domain should be able to view the report.