Dashboard Sharing and Manage Permissions in Power BI; Simple, but Useful?

Power BI provides multiple ways of sharing content with users. Each sharing method has pros and cons and can be used for specific scenarios. Some sharing methods can be used together to build a framework for sharing. This article and video discuss the most basic way to share Power BI content. This method is called Dashboard (or Report) Sharing. Dashboard sharing is the easiest way of sharing; however, it may not always be the best way. In this article and video, you’ll learn how this method works, you will learn about the pros and cons of this method, and the scenarios of using it.

Video

Power BI Content Owner

Before going through the dashboard sharing, you need to understand the content security in Power BI. When you publish a *.pbix report to Power BI Service, especially when you publish it under “My workspace,” no one else will see or have access to your report. It would be only you who has access to it. Then you can decide with whom you want to share this report.

Every Power BI content (report, dashboard, or dataset) has an owner; the content owner is the person who created and published that content into Power BI. The owner has full access to the content of Power BI. One of the owner’s accesses is sharing the content with others.

How does Dashboard Sharing work?

Dashboard or Report sharing, as the name explains, is based on a dashboard. You can only share a dashboard or report with this method, not a Dataflow or Datamart. Consider that you have a dashboard like the below screenshot, and you want to share it. There is a share link at the top right corner of the dashboard.

Share from a dashboard page in Power BI

Dashboard sharing has few options to set and is very simple to configure. You need to add the email address of the people with whom you want to share this report. You can also write a message for them to know that this report is shared with them. If you are sharing a report or dashboard, you may get two slightly different options. If you share a dashboard, you will get an option like this.

Sharing dashboard in Power BI

There are two options to set;

  • Allow recipients to share your dashboard
  • Allow recipients to build content with the data associated with this dashboard.
  • Send email notifications to recipients.

And at the top, you can enter the email of the people you share this dashboard with. For report sharing, the options are also similar with a small difference;

Report sharing in Power BI

By default, as you can see in the screenshot above, the “People in your organization with the link can view and share” is selected. This can be modified, but by clicking on it, you will then have options like the below;

changing the settings of report sharing in Power BI

You can choose whom to share the report with (the entire organization or specific people), and you can choose the access level of the audience to view, or plus reshare, or even plus build.

There are also options to share in multiple ways; Copy link, Mail, Teams, and PowerPoint.

After configuration, then you can click on the Share button. The recipient will immediately have access to the report. If you select “Send email notification to recipients,” they will receive an email. Otherwise, they get a notification in Power BI itself. When they log in to the service (or in the mobile app for Power BI), they can find this dashboard or report under the Browse and then “Shared with me” section.

The “Shared with me” section in the Power BI service

The recipient can also access the report or dashboard through the link. An important point here is that those with whom the report is shared should have a Power BI Pro or PPU account to see the content (this is one of the limitations of this method of sharing).

Three Levels of access

With dashboard (or report) sharing, users will have three levels of access; Read, Read and reshare, and Build. If you give them access without selecting the option “Allow recipients to share your dashboard, ” this access is Read. If you choose the option mentioned above, the access is Read and Reshare. And to give the Build access, you need to select “Allow recipients to build content with the data associated with this dashboard.”

Build access provides the ability to connect live to the dataset. This live connection can be done through the Power BI Desktop, through a new report inside the Power BI service, or using Analyze in Excel. The live connection to a dataset in Power BI is a great step towards a multi-layer architecture for Power BI development.

Manage Permissions

Another way of setting access is through Manage permission in the dashboard, report, or dataset. If you share a dashboard, by default, the report and the dataset will also be shared as read-only for users. Users can click on the dashboard and go to the report; they can interact with the report quickly. However, they cannot Edit the report. Access to edit reports cannot be provided through this method.

To manage permission on every item (dashboard, report, or dataset) individually, you can go to Manage Permission in the more options of the object.

Manage permissions on the Power BI report, dashboard, or dataset

Manage permissions will show you a detailed access list to the dashboard, reports, and datasets. You will see related reports and datasets on the left-hand side of the Manage Permissions section. You can click on the report.

Related content in the Manage permissions setting

Access can be seen through links or Direct access (directly authorized through the Manage permissions). You will see the permission specified for that object by clicking on a report or dataset. And you can change it. For example, user reza@radacad.com has access as Read to the report in the below screenshot (because we shared this dashboard with him, the report sharing happened automatically after that). You can remove that access by clicking on more options.

Changing the access levels through the Manage permissions

You will see the Remove access window, which asks whether you want to remove access to some of the related content or not.

Removing access to the related items in Power BI

If you remove access to other items, you should be careful because that item might be used in multiple other objects. For example, if you remove access to the dataset, that dataset might be used in multiple reports.

If you shared a dashboard with a user but removed access to the report or dataset, the user will see the error message for tiles coming from that report when logged in and accessing the dashboard. Users cannot drill into the report because they don’t have access.

Licensing part of this sharing

Dashboard or report sharing, like many other Power BI methods, is a paid feature. The account sharing the content should be a Power BI Pro account (Or PPU), and people using the shared content should be part of a paid account Power BI Pro account or PPU. Free users cannot leverage content shared with this method of sharing.

Advantages of Dashboard Sharing

Dashboard (or report) sharing is the most basic way of sharing content in Power BI. This method is quick and easy to set up. You don’t need to have a lot of steps to set up sharing of the dashboard. The ability to share it very quickly makes this method the most common method of sharing for testing.

If you have created a Power BI content and want to share it with others easily just for Testing, one of your first options in Dashboard sharing.

Disadvantages of Dashboard Sharing

Dashboard sharing is simple; however, it has many drawbacks, which make it hard to be used in production. I do not recommend using this method to share Power BI content with users in a production environment because of the reasons mentioned below;

No Edit Access

With Dashboard sharing, you cannot specify edit access. For end users, you never want to give edit access; however, if you are working with a team of developers and want to provide them with access to edit the content, you cannot do that with dashboard sharing. You have to use other sharing methods, which will come in the next few articles.

Share Objects one at a time

You can only share one dashboard at a time. What if you wanted to share hundreds of dashboards? You must go to each dashboard and share items individually. Sharing every dashboard would add a lot of maintenance overhead to your work. The best would be having all contents under a group and sharing it with others at once.

Licensing for a Large user base

If you have thousands of users to share the Power BI report with, Then this method is expensive. A Power BI Premium capacity can be set at the workspace level, and then Free Power BI users can consume the content using Power BI Apps, which is a more cost-effective way.

Summary

Dashboard or report sharing is straightforward; it has three access levels: Read, Reshare, and Build. You can use this method efficiently for test scenarios. When you want to share a dashboard with a user for testing, Dashboard sharing can be one of the best options.

Dashboard sharing, however, has some disadvantages. There is no Edit access to this way of sharing, and on the other hand, if you want to share multiple items, you have to go to each dashboard and share individually from there. Because of these two significant limitations, dashboard sharing is never used in the development or production environment of Power BI implementation. Other methods, which I explained below, can cover these limitations.

Reza Rad on FacebookReza Rad on LinkedinReza Rad on TwitterReza Rad on Youtube
Reza Rad
Trainer, Consultant, Mentor
Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for 12 continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand, Power BI Summit, and Data Insight Summit.
Reza is author of more than 14 books on Microsoft Business Intelligence, most of these books are published under Power BI category. Among these are books such as Power BI DAX Simplified, Pro Power BI Architecture, Power BI from Rookie to Rock Star, Power Query books series, Row-Level Security in Power BI and etc.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer.
Reza’s passion is to help you find the best data solution, he is Data enthusiast.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.

18 thoughts on “Dashboard Sharing and Manage Permissions in Power BI; Simple, but Useful?

  • HI RAZA RAD,
    Dashboard sharing share only Dashboard or Reports also?just i am test both report and dashboard can share using MY workspace.

    Thanks
    Aruna

    • At the very beginning, it was only an option for Sharing Dashboard for a while, recently it is possible to do for reports too. that is why I updated this blog post.

  • Hallo, Is it possible to avoid user to change filters at shared Report ? I do not want them to be changed.
    Thanks a lot for answer
    Renata

    • Hi Renata.
      Before I answer that; I should mention this:
      When you share content with the end user. They can change filters. However, that change is only for themselves. and won’t be saved back and won’t be visible for other users.
      However, that said, if you still prefer the user to not even change that. the using the new Filter pane. you can lock any filter card you want and don’t allow users to change it.
      Cheers
      Reza

  • Hi Reza Rad,
    This post is very useful! Thanks for making it so simple to understand.
    I do have a question w.r.t sharing specific pages of reports with users.
    Assuming RLS is applied to a pbix file , would it be possible to share a particular set of report pages of the pbix file to the relevant role? (i.e hiding a few report pages from the users)

    Thanks in advance,
    Varsha

    • Hi Varsha
      You cannot set the security based on the visuals or pages. You can set it based on the data and the model.
      If you want certain pages not to be available for everyone, the best is to create a different PBIX file for that

      Cheers
      Reza

  • Hi Reza,

    When I’m sharing the report with a group then the group members are not receiving email notification.

  • Hi Reza,

    I am a pro user and earlier when I published a report in My Workspace, I was able to share that with any other free user and the free user was able to consume that. But now, when the free user tries to open the report, it asks for license. Am I doing something wrong or MSFT has changed this?

    • Hi Vipul.
      A very long time ago, you could share a report with a free user. but the licensing has changed from around 2017. Sharing is not a free option anymore. the only free (but not secure) option is Publish to Web.

  • Hi Reza,

    My company has 5 products with 200 sales points, each sales point has 5-10 salesmen.

    I want to share dashboard with data part which relevant to each employees.
    For example:
    i) Each Head of Product can read the dashboard of all sales points and salesmen that sell that Product.
    ii) Each Head of Sales Point can see dash board of all products of all salesmen in that Sales Point.

    So How I can do the data permission management in this case.

    Thanks for your help.

    Linh, from Vietnam
    Email: hoanglinhnt@gmail.com

  • Hi Reza,

    I have a workspace and have 5 reports in it. I want the user to have only access to only 2 reports out of the 5. Can I restrict that?

    Thanks

    • You can use the basic sharing and share each report individually even though they are in a workspace. Better option, however, is to create an App for that workspace only for the two reports, and share it with that user.
      Cheers
      Reza

  • Hi,
    If an user that owns a dashboard leaves the company how can the dashboards be deleted?
    Thanks!!!!

    • Hi Jose
      It is always recommended to create the content not in “My workspace”, but in an organizational workspace. if the author of that content leaves the company, others can be assigned to the role of Administrator, Member, or Contributor of that workspace, and will be able to delete it.
      Cheers
      Reza

  • Hi,
    How does the role of Administrator, Member, and Contributor get assigned in a workspace?
    I created a report and published it. And, I shared it giving read or read & reshare. I have Member access. How do I grant someone Member access? Or is it the same as read & reshare?
    Thanks,
    Donna

Leave a Reply