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?
Solved! Go to Solution.
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.
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