The POWER of Microsoft Lists and Power BI

Learn how Microsoft Lists / SharePoint Lists can take advantage of Power BI! Daniel walks through how easy it is to start using today!

Create a report quickly from a SharePoint list or library

Daniel Glenn:


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #SharePoint #GuyInACube

[olozmada]

I'm using both lists and PBI together. Power Automate in between takes weekly snapshots from the list and ingests into PBI. Reports in PBI compare snapshots and trend KPIs with both the list and Power BI reports surfacing as tabs in the Teams channel. This simplifies the end user experience; keep the data current in the list and view reports one tab over. Awesome presentation :)

[DanielGlenn]

Look I'm in another video! I think we should take over Patrick's cube more often!

[cristian.angyal]

WOW ... I need to try this .
I installed the MSFT Lists App a few days ago but never tested the integration.
Already have some use-cases in mind ... and you gave me homework :) .

Thanks for sharing this!

[Ballistik]

Pulling together the Power Platform tools is where the magic happens. I have been developing Power Apps canvas apps for various use cases and storing the data within a List.. I then take that data set and generate visuals in Power BI which I then embed right back into the canvas app with a nightly refresh scheduled. Works great and our users enjoy seeing the visuals right within the app.

[bi-ome]

One of the advantages of using SharePoint lists is being able to expand the "people" type profile fields to get things like user department, manager, UPN, etc. It looks like this integration just pulls the "name" field; I hope they add this into their integration in the future.

[jamess]

Have not used Microsoft Lists directly in my organization, but like the seemingly smooth integration to get up and running using a List as a dataset in a new PowerBI Report.

[toma]

😄😄 I love the Absolutely NOT part. Ahh, what comes easy in this world anyway 😂

[meghanbosanko]

Thanks Daniel and Adam - handy tip! I'm curious how/if multi-select list fields are modelled. It's a Lists feature my team loves, but every time they create one, I wince because it's a pain to model.

[Metzanine]

Lists is great. And the PBI integration is useful.

Lists has a way to go before it catches up with Airtable though...

[AnilSharma-hlrb]

It awesome, but if I want to create any measure, can we create it?

[SeriousTyro]

Hi! I'm using Microsoft Lists and need to print rows, including large images. I've heard Power Automate might help, but I'm open to other solutions too. Could you share a tutorial on how to do this using Power Automate, or suggest any alternatives? Thanks!

[elrevesyelderecho]

2:11 Hi. When that "right-click-mouse" pane will be available in PBI Desktop? Thanks
It would be good to improve the user experience to have that quick menu ( like in PPT or Excel charts ) in PBI Desktop

[TheFuzzyskwerl]

Yes, love lists. Would appreciated more

[Shadeth]

I use a sharepoint list for people to enter weekly commentary, which then gets shown in a power bi report. However users want to see their comments immediately (as opposed to having to refresh the entire report).
Would love a direct query solution or a workaround for this if anyone knows anything!

[juanmanuel]

Adam, in my company are going to migrate from PowerBi to LookerStudio and GCP. I love PowerBi, how I can convince them to not do that? 😢

[Astronomynatureandmusic]

Power BI does not show whether or not a data set is auto-refreshed. And most of the time it does not refresh data unless you set up a gateway.

[stinaintx]

I really wanted to use this for a document library in SharePoint but that wasn’t possible.