topic Re: How to display in sharepoint? in Power Query

How to display in sharepoint?

Rowdy — Sun, 09 Aug 2015 22:35:49 GMT

Hi,

I'm trying to find out how to display my Power BI Dashboard in a SharePoint page on our Intranet. Is there a way to do this?

Regards,

Rowdy

Re: How to display in sharepoint?

Greg_Deckler — Sun, 09 Aug 2015 23:19:26 GMT

Well, you could try using the Page Viewer web part, essentially iframing it. Each dashboard has its own unqiue GUID.

Not really sure it is currently intended to be share out like that, might want to just include a link to it.

Re: How to display in sharepoint?

Rowdy — Mon, 10 Aug 2015 12:25:35 GMT

Hi Smoupre,

Thanks for the advise. I did give that a try before posting however I couldn't get it to work. I ended up with a Power BI signin page showing in the iframe. I'd see other sites with this data published such as

http://blogs.msdn.com/b/powerbi/archive/2014/12/11/embed-power-view-interactive-reports-in-your-blogs-and-websites.aspx

However they don't explain how they actually do it. It seems crazy that being able to display Power BI dashboards in Sharepoint isn't possible, it goes against the principle Sharepoint is built on.

Cheers,

Rowdy

Re: How to display in sharepoint?

konstantinos — Mon, 10 Aug 2015 14:11:21 GMT

Embeding PowerBI visuals is not yet supported..

The link you post is not from PowerBI service but from excel files with powerview sheets stored in onedrive business..(office 365, I think E3 and up )

https://support.office.com/en-us/article/Embed-your-Excel-workbook-on-your-web-page-or-blog-from-SharePoint-or-OneDrive-for-Business-7af74ce6-e8a0-48ac-ba3b-a1dd627b7773?ui=en-US&rs=en-US&ad=US

The limit is 10MB per file as in sharepoint online to render the file..

Also in a web part in a sharepoint oline site you can show a powerview report from excel file..Also needs to be stored in sharepoint online.

With some small changes you can make it work:

http://www.sqlchick.com/entries/2013/6/3/displaying-a-power-view-report-on-a-sharepoint-page.html

Re: How to display in sharepoint?

mstefancik — Tue, 11 Aug 2015 10:51:30 GMT

konstantinos

Do they plan to include this funcionality? As it is required funcionality from our enterprise customers to have dashboards embeded on one place.

You have to admit it makes sense.

Re: How to display in sharepoint?

andre — Wed, 12 Aug 2015 16:31:09 GMT

mstefancik embedding is on the official roadmap but Microsoft has not shared any timelines yet.

Re: How to display in sharepoint?

mstefancik — Thu, 13 Aug 2015 05:58:09 GMT

Hope that they will implement not only this but many minor changes which are nice to have features and allow users to do much more with visualizations.

Re: How to display in sharepoint?

pegah — Thu, 09 Jun 2016 13:26:54 GMT

There are few ways to do this, but I came across an issue with PowerBI refresh limitation when connecting to a SharePoint list, I have written a blog about how I overcame this issue. Here is a link, hope you find it useful.

Re: How to display in sharepoint?

gram1411 — Mon, 08 Aug 2016 16:34:29 GMT

I pegah, I ran into the same issue, I have a powerbi report connected to a SharePoint list and the report does not refresh after a while an I got the message "This content is unavilable". I try to acces your solution link, that there is an error whit it, could you please share it again?

Re: How to display in sharepoint?

bhanuchintha — Fri, 09 Sep 2016 09:07:19 GMT

Here is the solution -

http://rolandoldengarm.com/index.php/2016/04/27/part-1-how-to-embed-powerbi-in-a-sharepoint-site/

Thanks & Regaads,

Bhanu

Re: How to display in sharepoint?

httpftp123 — Fri, 11 Nov 2016 09:52:05 GMT

What are the key differences between the solution using SP Add-in vs. Power BI APIs (https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-integrate-report/)?

Thanks in advance!

Re: How to display in sharepoint?

Anonymous — Fri, 10 Feb 2017 00:55:23 GMT

We just shipped a web part for SharePoint Online, check it out: https://powerbi.microsoft.com/en-us/blog/integrate-power-bi-reports-in-sharepoint-online/

Re: How to display in sharepoint?

shrmehta — Fri, 10 Feb 2017 03:36:53 GMT

I am not getting an option in Sharepoint to add the Power BI (preview) web part. I got link from Power BI to embed in Sharepoint.

Re: How to display in sharepoint?

andre — Fri, 10 Feb 2017 14:54:39 GMT

you have to use Modern Pages feature to be able to embed Power BI in Sharepoint... Normal web parts page does not support power bi embedding....

Re: How to display in sharepoint?

TP — Thu, 16 Feb 2017 02:29:46 GMT

This is a great way to embed power bi dashboards and tiles in SharePoint. Using an app called LiveTiles for SharePoint

https://powerbi.microsoft.com/en-us/blog/livetiles-presents-the-new-power-bi-tile/

Re: How to display in sharepoint?

TP — Thu, 16 Feb 2017 02:39:29 GMT

There's a great way to embed Power BI dashboards and tiles into SharePoint using a new feature in LiveTiles SharePoint ( https://livetiles.nyc ) which is worth checking out. https://powerbi.microsoft.com/en-us/blog/livetiles-presents-the-new-power-bi-tile/

Re: How to display in sharepoint?

TP — Thu, 16 Feb 2017 02:41:46 GMT

Re: How to display in sharepoint?

bitsmythe — Tue, 21 Feb 2017 16:44:18 GMT

Hi, we just published a SharePoint add-in to the Microsoft Store that allows for Power BI reports and dashboards in SharePoint as well as sending Outlook Group notifications and alerts. You can see it here: https://goo.gl/cwEhQN

Re: How to display in sharepoint?

anandav — Thu, 09 Mar 2017 21:57:56 GMT

Hi,

I use SharePoint online with my company Office 365 account.

I created a Site page and embeded the Power BI report using Power preview web part. If I use the same account that I used to create the SharePoint embedding link from Power BI in SharePoint to login and view the Power BI report, all works well.

But, when another user in the organisation is accessing the page with hisown credentials for Offcie 365 and trying to view the Power BI report, it is giving an error ""This content isn't available." The user has Power BI Pro licence.

Any suggestions why this may be tha case?

Thanks,

Anand

Re: How to display in sharepoint?

Anonymous — Thu, 09 Mar 2017 22:01:12 GMT

This is most likely a permission problem. Check that the user can view the report if they view it directly in Power BI?