cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Titifeleke Frequent Visitor
Frequent Visitor

Can I upload and display a report built in power BI desktop to SharePoint site?

 

I want to display reports bulid in power BI desktop on my sharepoint site. I know I can piblish the report in

power BI desktop to power BI site and then embed the html code in sharepoint site page. But I don't want

to publish my report to cloud ( power bi site).  So is there a way to display the reports built in power BI desktop

on sharepoint site? I mean like we build reports on  excel client on our machine and upload to sharepoint.

 

 

Thanks, 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Can I upload and display a report built in power BI desktop to SharePoint site?

Only the 2016 version has the Power BI integration and support.

 

Currently, there is no auto-refresh capability outside of the Service. The exception would be if you use Direct Query, and then you do not need to refresh data, it is queried live at run time.

 

With regard to SharePoint Online, this used to essentially exist in Power BI "1.0" when Power BI was much more coupled with O365. However, that modeled kind of went away in Power BI 2.0 and I'm not really aware of any integration. However, it is coming and there is a third party tool for it:

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6740156-embed-in-sharepoint-offic...

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


4 REPLIES 4
Super User
Super User

Re: Can I upload and display a report built in power BI desktop to SharePoint site?

Your best bet right now would be to use SQL Server Reporting Services 2016 to upload your PBIX files to. Currently, they open in the browser but in the future, they will render the reports themselves locally (this is in the current CTP). You could iframe that SSRS page in SharePoint.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Titifeleke Frequent Visitor
Frequent Visitor

Re: Can I upload and display a report built in power BI desktop to SharePoint site?

Thanks a lot  Smpoure, can it be other versions of SQL Server Reporting Services or it must be the  2016 one? 

The other thing is after the PBIX files are uploaded to SQL Server Reporting Services, is there a way to referesh the report when there is a change on the data source?

 

what about sharepoint online site? is there any way?

 

THANKS AGAIN!

Super User
Super User

Re: Can I upload and display a report built in power BI desktop to SharePoint site?

Only the 2016 version has the Power BI integration and support.

 

Currently, there is no auto-refresh capability outside of the Service. The exception would be if you use Direct Query, and then you do not need to refresh data, it is queried live at run time.

 

With regard to SharePoint Online, this used to essentially exist in Power BI "1.0" when Power BI was much more coupled with O365. However, that modeled kind of went away in Power BI 2.0 and I'm not really aware of any integration. However, it is coming and there is a third party tool for it:

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6740156-embed-in-sharepoint-offic...

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Titifeleke Frequent Visitor
Frequent Visitor

Re: Can I upload and display a report built in power BI desktop to SharePoint site?

Thank you so much Smpoure, this helps me a lot.