Microsoft SharePoint | Get Valuable Insights from your Lists with Power BI

In this video we're going to look at a new feature coming to SharePoint that will let us visualise our list data in Power BI - Microsoft's tool for understanding data.

🎵 MUSIC: Interchange by Public Memory

🎓 🎓 Want more Microsoft 365 classes? Take a look at our school:

🤝 CONNECT WITH US:

[hirengahlot]

I agree that it is not justifiable and economical to spend extra on power BI pro for this add on. This should be given with a Microsoft 365 subscription

[louismajor]

Great video as always. Keep them coming! Very interesting to see direct interaction now offered by default from lists to Power BI within the Power Platform. Question: do you know if, in an Sharepoint extranet setup, external collaborators can access the Power BI view from a List if they do have a Pro license provided within their own tenant?

[arunavasarkar]

I don't see the edit button, what may be the reason? Thank you in advance

[andrewpndavies]

Very good video. I’ve tried setting up my own report from Microsoft lists data and all good. Except I can’t show images. It just says [Record]. Any suggestions?

[martinschlenker]

As always: Great video, fantastic explanation. thanks for this great work. Good to have a source which is very often "one step ahead".
I agree with your opinion that lots of customers will argue that they can do the same in Excel. Especially with the fact that a list in SP is a fantastic source for Excel. So why pay an extra amount for something which is already there and proven ? I hope Microsoft will pick up this and will offer some special deal with Power BI as part of a MS 365 BI license, which might be on top of Business Premium / E3 with an additional cost of 2€ plus or something like this. This could start an easy adoption from many I guess :-) Just my few cents :-)

[davidcarrico]

Is there a way to report on choice columns that allow for multiple values? So if I have a 3 choice column (‘a’, ‘b’ and ‘c’) that allows multiple values. If I have 20 rows with the first 10 have a value of ‘a’ and the second 10 having a clue of ‘b’ and the rows 8 through 12 also have a value of ‘c’ (so rows 8 through 10 have two values of ‘a’ and ‘c’ while 11 and 12 have values of ‘b’ and ‘c’). Now I would like to creat a visual in PowerBI that has 3 columns, one for each value of ‘a’, ‘b’, and ‘c’ and the column shows the count of each so ‘a’ (10), ‘b’ (10) and ‘c’ (5)? From my experimentation PowerBI from lists isn’t differentiating the values so instead of 3 values it sees 5 ( ‘a’, ‘b’, ‘c’, ‘a, c’ and ‘b, c’). Does the integration function not support that (in other words, to do what I want, will I not be able to use PowerBI from the integrate menu item in Lists, but instead need to first create a PowerBI dataset from the List as a data source that uses powerquery to pull out those multiple value rows into their own rows?)?

[MatthewLCarter]

Always more money for stuff. So expensive!

[sheldonedwards]

Apologies... I haven't even watched the video... But I can't image a video trying to combine one of the best modern data analytics tools... With one of the most redundant, worthless pieces of #$@&#+ Microsoft software ever 😅