I have learnt a lot about sharing Power BI content over the last year since Power BI hit the main stream. A lot of my learning has come from trial and error, and there are lots of things I wish I knew before I started. Today I am sharing my top tips about how you can share, and when you should use each of the various methods
It is not easy to categorise the sharing approaches into logical buckets and there is quite a bit of overlap. Hopefully my explanation below will make it easier to understand the options.
The most basic way to share your Power BI content is to simply share your PBIX workbook (created by Power BI Desktop) using traditional methods. There are a few reasons why you might want to do this.
|Reasons you might want to do it||Things that might turn you off.|
So while you can do it this way, sharing via the Power BI Service is probably a better way to go. Power BI Service was built for the explicit purpose of sharing, so why not use it – its free to get started.
Once you sign up to the Power BI Service, the default location where you will publish your workbooks is the “My Workspace” area.
- The workspace area is a place for you to store your Datasets, Reports and Dashboards.
- You are the only person that can see the items in you own “My Workspace” (unless you explicitly share material)
- Items that other people share with you will also be visible in your own “My Workspace”, but with a “shared with me” icon.
Sharing from My Workspace (use caution)
There are 3 ways you can share from My Workspace. These methods of sharing are also available in other areas of Power BI (covered further down the page). While you “can” share this way from My Workspace, be sure to read up on the downsides of sharing this way and consider the other options further down the page.
Here are the 3 options to share from My Workspace.
Share a Dashboard from My Workspace
Click on the ellipsis next to the dashboard to bring up the sharing menu. You can share to individual email addresses or to Active Directory Groups. It is possible to securely share a dashboard this way with people internal to your organisation (email domain) as well as with people outside of your organisation.
Publish to Web from My Workspace
Sharing this way allows you to make the material publicly visible over the web. You can get an embedding code to publish the material via a web page (see this example in a recent blog) or you can get a link that you can send to anyone. But be careful! Even if you send the link to a single person, the material is available to anyone that has the link (or can find it, hack it etc) – no password required.
Create a Content Pack from My Workspace
A Content Pack is a bundle of Datasets, Reports and Dashboards that can be distributed to defined users in your organisation. When you create the Content Pack, you can specify individual users or groups of users via Active Directory.
If someone wants to access this data shared with them as a Content Pack, they simply click “Get Data” and select the content pack from “My Organisation”
The benefit of sharing via Content Packs is that you can bundle relevant material and share with only those that need it. They can choose to access it only when they want it.
There are some downsides of sharing from My Workspace
Here are the pros and cons of sharing this way from My Workspace. Remember it is possible to share using these methods from a Group Workspace too – more on that below.
If you are serious about sharing material, then you really should start using Group Workspaces. Group Workspaces are a Pro Licence feature, but it is almost a must for any organisation serious about sharing content via Power BI.
The benefits of using Group Workspaces vs My Workspace include:
- More than one person can publish, edit and manage all content within a Group Workspace.
- One or more people can administer user access to the Group Workspace.
- If the original author is not available (ie they are on holidays or they leave the company) then someone else can take ownership of the material without starting again from scratch.
- You can have as many Group Workspaces as you need, and these can be based on any group categorisation that works for you and your organisation.
- When you have your shared material in a Group Workspace, there is no confusion as to what is your personal material and what material you have loaded for the purpose of sharing (see below how you can categorise the Group Workspaces).
Once you have decided to use a Group Workspace, you have the same sharing options as covered earlier with all the same benefits.
- Share a Dashboard
- Create and Share a Content Pack
- Public Sharing – Publish to Web
Sharing Group Workspaces
The final method of sharing is to share the Group Workspace itself. You can of course share the Group Workspace for the purpose of “administration”, but you can also share with the purpose of Group Collaboration and/or Content Sharing. You have the ability to set access for individuals to be either an administrator or a member. Admin always has full privileges. Members can be configured by an administrator to either be all “editors” or all “viewers” depending on the group requirements. One limitation is that you can only share a Group Workspace with individual email address users, not an Active Directory group. If you think that is just wrong (as I do), then please vote here to have this changed.
Hopefully this article has helped you gain a deeper understanding of the sharing options available with Power BI. Microsoft has announced it is reviewing a new idea called Private Publish to web, so keep an eye out for that, and vote for it if you like the idea.
Sharing Directly In Excel
As pointed out by Anthony (in the comments below), once you have access to shared data via Power BI, you will have access to another KILLER feature – direct access to the data from within Excel. There was a new update on this today, and I blogged about it here. https://exceleratorbi.com.au/direct-connect-excel-power-bi-service/