For all of you out there who have had challenges with embedding your Power View dashboards into your public-facing websites, here is the fruits of my labors attempting to and finally achieving success in doing just that. There’s no new revelations here, consider this to be more of a compendium of all the important information that’s out there on this subject.
Making your Power View Report Available to the Public
This was one of the biggest challenges I encountered. While there are many examples of how to create a guest link, all the resources I found did not give the full picture of what you need to do to make this possible.
Set up your SharePoint Site for Anonymous Access
Before you can share your Workbooks with the public, you’ll need to make sure you set the sharing up properly within the SharePoint Site Collection Admin screen for the site where your document will live. Check out the link below for more information on configuring your SharePoint Site. The main takeaway here is that you choose the third option for “Allow both external users who accept sharing invitations and anonymous guest links” so that you will have the option later to share your workbooks with the public.
Sharing a document library or SharePoint site with an external user
Sharing your workbook with the public
Now that you’ve configured your SharePoint site to allow anonymous to be available, you need to share each file you want to embed with the public. There’s some information in the earlier link on doing this, and here’s another good resource for how to share your file:
Embed your Excel workbook on your web page or blog from SharePoint or OneDrive for Business
They key is to get that guest link that you need in order to create your embedded view. You can play around further with the URL parameters to tweak how the embedded object (see the link above for details).
Embedding your Power View dashboard into your site
Create an iFrame with your guest link as the src
All you need now is to create an iFrame in your blog/site and use the guest link you obtained above as the source. This turned out to be more of a challenge than I thought it would be for this blog post as WordPress by default strips out iFrames, so I had to have a plug-in installed and yadda, yadda, yadda. Ultimately though, if you can get an iFrame to work on your blog/site, you should be able to put that guest link into the source and your embedded Power View should pop up! See my example below of a Power View dashboard we created at Tallan for other demonstrations. My example is on the smaller side but you can use the standard iFrame size parameters to size your embedded dashboards appropriately.
You may experience an issue with security in IE and using iFrames. I do not profess to having any understanding on how the whole IE security model works but this blogger seems to have worked out the IE settings they needed to set in order to make IE work with the embedded iFrame.
Click around below to see my Power View Embedded Sample work[pageview url=”https://tallaninc-public.sharepoint.com/_layouts/15/guestaccess.aspx?guestaccesstoken=LVz9g08nP9YNYEUpF3RJqX0dJLVq76cCDUPfUGz3Mgo=&docid=08251c28b1fc547c1a40f1a183d967b42&action=embedview&wdBIPreview=1″ border=”yes”] [su_lightbox src=”https://tallaninc-public.sharepoint.com/_layouts/15/guestaccess.aspx?guestaccesstoken=LVz9g08nP9YNYEUpF3RJqX0dJLVq76cCDUPfUGz3Mgo=&docid=08251c28b1fc547c1a40f1a183d967b42&action=embedview&wdBIPreview=1″]Click Here for a larger view[/su_lightbox]