Microsoft Lists integration with Power BI

We are excited to announce the release of a new guided experience in Lists that will make it easy to create business intelligence reports in Power BI using your list data as your source.
List users will see a new menu option in Integrate, then Power BI, then "Visualize this list", which allows users to create a new Power BI report using that list. With just one click, you'll be able to autogenerate a basic report and customize the list columns that are shown in the report. To take further advantage of Power BI, go into Edit mode. Once a report is saved and published, it will appear in the same Power BI submenu under Integrate.
Users with a Microsoft 365 E5 license or Power BI Pro license will have access to the full report authoring and viewing experience. Users without either of those licenses will be prompted by Power BI to sign up for a 60-day free trial of Power BI Pro when they attempt to save a new report or edit or view an existing report. You can turn off self-service sign-up so that the option for a trial is not exposed to List users, click here. Users with a Power BI free license may only visualize their list data but cannot publish nor view reports.
Get started creating in the Power BI service: powerbi.microsoft.com/blog/qu...
Create a list from Excel (video): • Microsoft Lists - crea...
Learn more about Microsoft Lists: aka.ms/MSLists

[@ekkiwurm7874]

Excellent little & short video. Brilliant content and speed of presentation. It also showed my the solution for a task that seemed unsolvable. Thank you so much for producing and sharing this clip.

[@j.pablo.r.p7780]

muchas gracias! excelente video! I applied what I learned in the video in my work and it turned out incredible! thank you

[@2007pradipta]

Great feature added...thanks for the demo...one question i have..does powerbI will refresh automatically when there is change in list?

[@KI_Burgberg_DE]

And why does the PowerBI data does not update instantly?

[@deniscloutier383]

Greeeeaaat video, thanks! One question, if a list is updated, does it immediatly sync with the PowerBI ? Do we need to use Power Automate to feed Lists data to PowerBI ?

[@olgamelo4416]

This feature is great, but new columns added to the list are not shown on the report data source. I've refreshed it, delete, recreate and nothing seems to work. Can some one tell me if you are experiencing the same issue? Thank you

[@davidcarrico3385]

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

[@samalas7293]

Thank you Mark or such a great tutorial. One (perhaps too easy for you) question: Microsoft List being so powerful tool and comparing it to Microsoft Tasks outweighs it by far, how come Tasks can send overdue tasks automatically to an owner of the task but List cannot do so? So far I could not find an easy way of doing so. Creating Flows in Power Automate takes so much time. Perhaps there is a way of doing that but it is not intuitive and I am sure other users struggling with this thus working on coding to create flows (that is not an easy task). Your response i much appreciated. Or perhaps you can add that functionality to the List?

[@amandas9597]

great addition

[@honeybunny7741]

How can I now embed this powerbi report back into sharepoint? And how can I delete the powerbi report associated (published) with the list when it is no longer needed?

[@ianfenelon6665]

Hi. I have used this cool feature recently. I have a question though - how do I refresh the data being used by the Power BI from the list? When I make changes to the List, it takes a while - hours - for the data to refresh in the integrated Power BI. Clicking the refresh button seems to have no effect. Clicking on the Data Updated dropdown shows it was refreshed a few hours ago. Thanks.

[@krzysztofgorski8075]

I try to share a Integrated Power BI, so I can reuse it for other MS Lists or share with my colleagues. What options are there?

[@selah47]

Is there a way to add measures??

[@gstdoctor]

Sum is not working when integrating Power Bi with Sharepoint list even though filed format is chosen as Number. Any suggestions?

[@thomasfoxl]

Is there a way to show the images in Power BI?

[@christopherrisher7230]

Is there a demo of the extension of Lists with Power Apps? I must be missing it somewhere.

[@chihabaroua7920]

any solution ?

[@KI_Burgberg_DE]

How can I see the report in PowerBI - App? It seems not be applicable

[@krishnaaveersinghhada9220]

Hi I have one question, if I need to create power app to update field in List. How would I do that? I have created the ms list and the power app .but when I am clicking submit in my power app form it is not updating the data in the list..any suggestions

[@sharensu4398]

May you advise why is my data in the person field not reflecting in the PowerBI?

[@davidcarrico2423]

So in my tenant, if I try to "Get more visuals" after going into edit the page that pops up after selecting teh PowerBI integration, nothing happens. Is this function not supported in this integration, or is there something wrong with my setup? Not sure if this matters, but I have a PowerBI Pro license.

[@SKepicfail]

The same, it's big limitation of this integration. Do someone know how to connect Microsoft List to Desktop Power BI? Assuming desktop version can overcome this.

[@johnbrennan8442]

Hello how can you prevent share point showing in power Bi please

[@arunavasarkar3744]

Hi, I don't get the edit option on the report. What might be the reason? Thank you in advance.

[@kuanyshtazhibayev5738]

Hi, did you find edit button? Ive got same problem

[@arunavasarkar3744]

@@kuanyshtazhibayev5738 Not yet. I cannot see the edit button.. not sure what might be the reason

[@LucasSoares-nl6tu]

Is it possible to insert another list in this powerbi?

[@dagcummings6457]

Thanks for a great and very useful demo, when will this feature be avalabel from?

[@cottagekeeper]

Is Power BI part of Office 365?

[@jacek8889]

when its will be alviable

[@gathutmawahyujatmiko5849]

How about the reverse? Is it possible to send a data from power bi to list?