cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
DorianF New Member
New Member

I need some info on publishing PBI to SP

Hi,

 

I'm new to Power BI. Getting my marks on the desktop application, this tool definitely seems to be what I need.

I'm getting data from my sharepoint intranet's lists and displaying them in a more intelligible way for my users.

 

Now, I'd like to have these power BI views integrated to my Sharepoint site.

I've read a couple solutions on different articles / forums, but most of them are not up to date and present some aspect that won't do for my project.

 

So, basically my questions are the following :

1 - Can I integrate my power BI charts to SharePoint (they'd be directly displayed, not downloaded by the users) ?

2 - Would the charts automatically update when my users update the SharePoint lists ?

3 - Would my data remain private ?

4 - Would this require some special configuration on the Sharepoint server ?

5 - Is there an additional fee to add such a feature to my web site ? (my client already has Power BI and Sharepoint)

6 - Would you happen to have a link for an up-to-date tutorial to do this ?

 

Thanks for your insight !

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: I need some info on publishing PBI to SP

 Hi @DorianF,

Firstly, you can integrate your Power BI charts to SharePoint using Power BI Embedded feature or creating SharePoint Online App/Add-In Part. There are some blogs for your reference.

http://rolandoldengarm.com/index.php/2016/09/13/part-3-how-to-embed-a-power-bi-report-in-sharepoint-...
http://www.imgroup.com/embedding-power-bi-sharepoint-online/

Secondly, you can schedule refresh for your dataset in Power BI Service, this way, when there are any changes in SharePoint lists, charts will be updated in Power BI Service. However, once you integrate Power BI reports in SharePoint, the reports in SharePoint will not be updated automatically because Power BI embedded doesn’t support refresh for import mode dataset. I am afraid  that you have to refresh the PBIX file manually and re-import each time you have updated data at the current time. Or you can utilize Azure database as described in the above blog to achieve automatic refresh.

Thirdly, your data are secured and  private.

In addition, you may need to pay for Azure features used in the above blogs.


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Moderator v-yuezhe-msft
Moderator

Re: I need some info on publishing PBI to SP

 Hi @DorianF,

Firstly, you can integrate your Power BI charts to SharePoint using Power BI Embedded feature or creating SharePoint Online App/Add-In Part. There are some blogs for your reference.

http://rolandoldengarm.com/index.php/2016/09/13/part-3-how-to-embed-a-power-bi-report-in-sharepoint-...
http://www.imgroup.com/embedding-power-bi-sharepoint-online/

Secondly, you can schedule refresh for your dataset in Power BI Service, this way, when there are any changes in SharePoint lists, charts will be updated in Power BI Service. However, once you integrate Power BI reports in SharePoint, the reports in SharePoint will not be updated automatically because Power BI embedded doesn’t support refresh for import mode dataset. I am afraid  that you have to refresh the PBIX file manually and re-import each time you have updated data at the current time. Or you can utilize Azure database as described in the above blog to achieve automatic refresh.

Thirdly, your data are secured and  private.

In addition, you may need to pay for Azure features used in the above blogs.


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 420 members 3,759 guests
Please welcome our newest community members: