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

AUTOMATED POWER BI REPORT FROM SHAREPOINT LIST

Hello,

 

I am a very novice user of POWER BI and SharePoint (Using free version of Power BI)

 

What I am trying to achieve is:

 

A) I would like to have a SharePoint list (which individual employees add information to and update regularly)

B) I'd like this list to act as the data set in Power BI to generate a chart

C) I'd like to embed this chart into SharePoint page

D) I'd like the chart to update and display current data as more information is added by users to the SharePoint list

 

A-C I have a handle on, but am struggling with getting the data from SharePoint list (as updated) to update in PowerBI live, and then display the most updated chart in the embedded Power BI in SharePoint....

 

Can anyone help or suggest solutions?

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: AUTOMATED POWER BI REPORT FROM SHAREPOINT LIST

Hey
unfortunately, is not possible with a free license.

Regards,
Tom
Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
5 REPLIES 5
jar2019 Regular Visitor
Regular Visitor

Re: AUTOMATED POWER BI REPORT FROM SHAREPOINT LIST

How are you reading the dataset from SharePoint? You might need to go into settings on powerBI Service. Then go to datasets. Then go to your report that you built. Then make sure your credentials are set up. Then Schedule Refresh. Voila. 

pmelo Frequent Visitor
Frequent Visitor

Re: AUTOMATED POWER BI REPORT FROM SHAREPOINT LIST

Worked perfect! The dataset is now updating as scheduled, and updates also if I click REFRESH NOW

 

My last issue is getting the embedded code to show the updated report on the SharePoint page...

 

Is this possible?

 

Since I am on the FREE PowerBI I had to use "Publish to Web" to get an embed code, and then use the SharePoint webpart "Embed Code" to add the Power BI Embed Code so the Power BI report shows

 

 

 

 

 

 

jar2019 Regular Visitor
Regular Visitor

Re: AUTOMATED POWER BI REPORT FROM SHAREPOINT LIST

I’m glad it worked! Keep in mind that your end users will not have a refresh button so it truest is my automated in that sense. Just set a schedule up and you will be gold. Publish to web gives the whole wide world access to the data so be certain there is not any confedential data included in your report you aren’t willing to share with everyone.

If I answered your question please mark as answered.
jar2019 Regular Visitor
Regular Visitor

Re: AUTOMATED POWER BI REPORT FROM SHAREPOINT LIST

Also, share point uses a rest API and will automatically update every few minutes and after the browser has been refreshed
Super User
Super User

Re: AUTOMATED POWER BI REPORT FROM SHAREPOINT LIST

Hey
unfortunately, is not possible with a free license.

Regards,
Tom
Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!