The POWER of Microsoft Lists and Power BI

[@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!

[@Ballistik3]

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.

[@jamess7033]

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.

[@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.

[@DanielGlenn]

You would have to add some other functionality using Power Automate for instance to pull that out in the list. But being able to handle that with an Active Directory integration with PBI would great.

[@bi-ome]

@@DanielGlenn You can pull it with PBI if you’re connecting using the SP list connector. It’s just not in this “create the dataset for you”-style integration.

[@TheFuzzyskwerl]

Yes, love lists. Would appreciated more

[@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

[@bbuye03]

I have a Microsoft list, and I want to make a copy of it. Do I export to Power BI, then in my Teams Channel for my Project I want create a new list, where to I import that list from Power BI?

[@AnilSharma-hl6rb]

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

[@d9552g]

Once you create the dataset based on the list, it acts just like any other dataset.

[@meghanbosanko1391]

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.

[@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!

[@Metzanine]

Lists is great. And the PBI integration is useful. Lists has a way to go before it catches up with Airtable though...

[@toma4528]

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

[@DanielGlenn]

I often have to have that convo :)

[@Shadeth135]

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!

[@mitesharora649]

Facing the same issue, and can't switch to Dataverse any time soon! It can update the report in real-time.

[@juanmanuel4985]

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? 😢

[@po-weihuang3398]

Could you share why looker is better? I’m from Power BI team too. Sad to hear this😢

[@stinainsd]

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

[@DanielGlenn]

No, it isn't. I know of no future plans for the product team to do that unfortunately.

[@DanielGlenn]

You CAN visualize a document library, just can't import as a dataset.

[@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.

[@Megaknaak]

Needs DQ functionality