This article is retired, but kept for posterity. The current version of this article can be found here.
Level: Beginners
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.
PBIX Workbooks
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.
My Workspace
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.
| Pros | Cons |
|
|
Group Workspaces
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/

I was reading some of your posts on this website and I conceive this web site is really informative ! Keep on posting.
I am continually invstigating online for ideas that can benefit me. Thanks!
great points altogether, you simply gained a new reader. What would you suggest about your post that you made a few days ago? Any positive?
Very interesting points you have mentioned, thanks for putting up. “Great is the art of beginning, but greater is the art of ending.” by Henry Wadsworth Longfellow.
obviously like your website however you have to check the spelling on quite a few of your posts. Many of them are rife with spelling problems and I in finding it very bothersome to tell the truth then again I’ll surely come back again.
I would like to thnkx for the efforts you have put in writing this blog. I am hoping the same high-grade blog post from you in the upcoming as well. In fact your creative writing abilities has inspired me to get my own blog now. Really the blogging is spreading its wings quickly. Your write up is a good example of it.
Good ?V I should definitely pronounce, impressed with your web site. I had no trouble navigating through all the tabs and related info ended up being truly easy to do to access. I recently found what I hoped for before you know it at all. Quite unusual. Is likely to appreciate it for those who add forums or anything, website theme . a tones way for your client to communicate. Excellent task..
Thanks for the sensible critique. Me & my neighbor were just preparing to do a little research about this. We got a grab a book from our area library but I think I learned more clear from this post. I’m very glad to see such wonderful info being shared freely out there.
Satirical writing is the sugar coating that makes bitter pills of truth easier to swallow. — Alan @ comedywriter.info
It’s the news that understands that sometimes, you have to be ridiculous to be right. — Toni @ Satire.info
What¦s Taking place i’m new to this, I stumbled upon this I’ve discovered It positively useful and it has helped me out loads. I am hoping to contribute & aid different users like its helped me. Good job.
Hello. impressive job. I did not anticipate this. This is a excellent story. Thanks!
Thank you for sharing with us, I believe this website genuinely stands out : D.
I always was concerned in this subject and still am, regards for posting.
Hello! I could have sworn I’ve been to this blog before but after browsing through some of the post I realized it’s new to me. Anyways, I’m definitely happy I found it and I’ll be bookmarking and checking back often!
I beloved as much as you will receive performed right here. The cartoon is attractive, your authored material stylish. however, you command get bought an shakiness over that you wish be turning in the following. in poor health certainly come more until now again since precisely the same nearly very ceaselessly inside case you protect this hike.
magnificent issues altogether, you just received a new reader. What might you suggest about your publish that you just made some days ago? Any certain?
I¦ve been exploring for a little for any high-quality articles or blog posts on this sort of space . Exploring in Yahoo I finally stumbled upon this site. Studying this information So i am happy to exhibit that I have an incredibly good uncanny feeling I found out just what I needed. I most definitely will make sure to do not put out of your mind this site and give it a glance on a continuing basis.
Enjoyed reading this, very good stuff, appreciate it. “Golf isn’t a game, it’s a choice that one makes with one’s life.” by Charles Rosin.
Hey just wanted to give you a quick heads up. The text in your content seem to be running off the screen in Ie. I’m not sure if this is a formatting issue or something to do with internet browser compatibility but I figured I’d post to let you know. The design look great though! Hope you get the issue solved soon. Many thanks
Great V I should definitely pronounce, impressed with your web site. I had no trouble navigating through all the tabs and related information ended up being truly easy to do to access. I recently found what I hoped for before you know it at all. Reasonably unusual. Is likely to appreciate it for those who add forums or anything, site theme . a tones way for your customer to communicate. Excellent task..
Some genuinely great info , Glad I discovered this. “I have hardly ever known a mathematician who was capable of reasoning.” by Plato.
It’s arduous to search out knowledgeable folks on this topic, however you sound like you know what you’re talking about! Thanks
The Pink Salt Trick is a minimalist but effective morning routine: Just drink a glass of lukewarm water mixed with a pinch of Himalayan pink salt as soon as you wake up.
Yay google is my king assisted me to find this outstanding internet site! .
Hi there very cool web site!! Man .. Beautiful .. Superb .. I will bookmark your blog and take the feeds also…I’m satisfied to search out a lot of helpful info here in the submit, we need work out more strategies in this regard, thank you for sharing.
As soon as I noticed this web site I went on reddit to share some of the love with them.
you are in reality a good webmaster. The site loading pace is incredible. It sort of feels that you’re doing any unique trick. In addition, The contents are masterpiece. you’ve done a great activity on this topic!
I know this if off topic but I’m looking into starting my own blog and was curious what all is required to get setup? I’m assuming having a blog like yours would cost a pretty penny? I’m not very internet savvy so I’m not 100 sure. Any recommendations or advice would be greatly appreciated. Thank you
I conceive this site holds very wonderful pent content material content.
I went over this site and I conceive you have a lot of great information, saved to bookmarks (:.
fantastic issues altogether, you simply gained a new reader. What would you suggest about your publish that you simply made a few days ago? Any positive?
You made several fine points there. I did a search on the subject and found nearly all persons will agree with your blog.
Great ?V I should definitely pronounce, impressed with your website. I had no trouble navigating through all the tabs as well as related information ended up being truly easy to do to access. I recently found what I hoped for before you know it in the least. Reasonably unusual. Is likely to appreciate it for those who add forums or anything, website theme . a tones way for your client to communicate. Nice task..
Great wordpress blog here.. It’s hard to find quality writing like yours these days. I really appreciate people like you! take care
Hey there! I know this is kind of off topic but I was wondering if you knew where I could get a captcha plugin for my comment form? I’m using the same blog platform as yours and I’m having problems finding one? Thanks a lot!
I am continually browsing online for posts that can benefit me. Thanks!
I was looking through some of your blog posts on this site and I believe this website is rattling informative ! Retain posting.
My coder is trying to persuade me to move to .net from PHP. I have always disliked the idea because of the expenses. But he’s tryiong none the less. I’ve been using Movable-type on a number of websites for about a year and am anxious about switching to another platform. I have heard good things about blogengine.net. Is there a way I can transfer all my wordpress content into it? Any help would be really appreciated!
I think this is among the most important info for me. And i am glad reading your article. But should remark on few general things, The web site style is wonderful, the articles is really excellent : D. Good job, cheers
Howdy very nice website!! Guy .. Beautiful .. Superb .. I will bookmark your blog and take the feeds additionally…I am glad to search out numerous useful info right here within the submit, we’d like develop more strategies on this regard, thanks for sharing.
Thank you, I’ve just been looking for info approximately this topic for ages and yours is the greatest I have discovered so far. But, what about the bottom line? Are you sure about the supply?
My brother suggested I would possibly like this blog. He was once totally right. This post truly made my day. You cann’t believe simply how so much time I had spent for this information! Thank you!
Hello my family member! I wish to say that this article is awesome, nice written and include approximately all vital infos. I would like to see extra posts like this .
I’m not sure why but this web site is loading very slow for me. Is anyone else having this issue or is it a issue on my end? I’ll check back later and see if the problem still exists.
Hi , I do believe this is an excellent blog. I stumbled upon it on Yahoo , i will come back once again. Money and freedom is the best way to change, may you be rich and help other people.
Great – I should definitely pronounce, impressed with your web site. I had no trouble navigating through all the tabs as well as related information ended up being truly simple to do to access. I recently found what I hoped for before you know it in the least. Reasonably unusual. Is likely to appreciate it for those who add forums or something, web site theme . a tones way for your client to communicate. Excellent task..
I’ve been absent for some time, but now I remember why I used to love this web site. Thanks, I’ll try and check back more frequently. How frequently you update your site?
What¦s Taking place i am new to this, I stumbled upon this I have discovered It absolutely helpful and it has helped me out loads. I am hoping to contribute & assist other users like its helped me. Good job.
I have been exploring for a bit for any high-quality articles or blog posts on this kind of house . Exploring in Yahoo I finally stumbled upon this web site. Reading this info So i am satisfied to express that I’ve an incredibly excellent uncanny feeling I came upon exactly what I needed. I such a lot surely will make sure to don?¦t overlook this web site and provides it a look on a constant basis.
I have not checked in here for a while since I thought it was getting boring, but the last several posts are good quality so I guess I¦ll add you back to my daily bloglist. You deserve it my friend 🙂
Today, while I was at work, my cousin stole my apple ipad and tested to see if it can survive a 40 foot drop, just so she can be a youtube sensation. My iPad is now broken and she has 83 views. I know this is completely off topic but I had to share it with someone!
Hi Matt,
Excellent article !
I m admin of my Power BI account (free account) and I wish to share my dashboards to more than 100 contacts.
But I don’t want them to reshare it.
What is the best, safest, cheapest solution in my case as I m starting my own business ?
Thank you very much for your nice feedback.
This is a big topic. I suggest you read my articles
https://exceleratorbi.com.au/power-bi-licences-changes-good-bad/
and this series of articles starting here =>
https://exceleratorbi.com.au/affordable-power-bi-premium-for-small-business-part-1/
Once you share, you can stop people re-sharing by publishing an “App” and turning off the re-share function.
This is a great article and provides clarity amongst a sea of options
There is an absolute killer feature which I will add to the above and is largely independent of Power BI for the end user / recipient (I.e. It has limited involvement for them)
1) Permission a user to access your Group Workspace where you have published your data model
2) Ensure user has the ‘Analyse in Excel’ workbook add-in downloaded from Power BI. This is a one off exercise and can be triggered by simply right clicking on the data model and clicking ‘analyse in excel’
3) With the necessary plumbing in place you can now create a workbook using Analyse In Excel with a connection via OLAP to the Power BI hosted model. You simply give this workbook to the end user knowing they can refresh it and always have one version of the truth. If they are confident they can also create their own workbooks
I’ve yearned for this type of thing for a while now and as soon as I heard about it, jumped on it. Having your data layer separated like this provides for thin client reporting workbooks connecting to their data source in Power BI. No need for Access databases, SSAS Tabular etc to host your data, Power BI provides the solution and is true ‘managed self-serve BI’. Tremendous
You are right Anthony, so you will therefore LOVE my post today https://exceleratorbi.com.au/direct-connect-excel-power-bi-service/
I just read it, fantastic !!!
Am I right in thinking that if I’m the publisher only one Power BI pro licence is required?
I don’t think it is related to who publishes it. In order to receive it via a content pack or group workspace, you need a pro licence. If you share via dashboard, the receiver can’t see the report or dataset.
Great post – This answered a few of my questionsl – Thank you Matt.
Matt, thanks for the helpful information.
Sharing Group Workspaces and Private Publish to Web just racked up a few of my votes. Really surprised that Sharing Group Workspaces (as of now) has only a few votes! If only people who have not voted yet would add their support, what a fantastic facilitator Group Workspaces would be!
Matt,
A very useful summary of all the options. We’re considering using the facility to Publish to Web, but embedding the code on a company extranet page. We’d then give our customers a login and password to the pages of the extranet reserved for them. I’ve been concerned about how secure this is though. In your opinion, just how likely or easy is it really to find or hack a publicly shared link? (My opinion is that we’re not MI5, so very few would want to bother – but our IT department may feel differently.)
I think the risk is low, but you have to balance that against the consequences if someone did access it. And could people copy the link once the accessed the extranet? The Private Publish to web is under review – consider using that. Plus direct share of dashboards also is secure and can be shared with external parties now.
Matt,
Excellent article. It brings some clarity to a sometimes confusing subject.
Question: Are companies putting their sensitive financial data on the cloud (ie ‘Publish to Web from My Workspace’)? How secure is it?
The Power BI capabilities are great and I want to share dashboards via a browser but how do I address these security concerns?
Certainly many companies are using Power BI and some are using it for sensitive financial data. Some are using internal SSAS Tabular servers and then using Power BI Service to access and display the data. In this use case, the data at rest is not in the cloud, but the data in transit IS in the cloud. Some see this is more secure. Each company needs to make its own assessment. There is a good article and white paper here
https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-power-bi-security/
Personally, I would not be making the decision myself, but getting the company information security manager to make a call.