cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors