No video :(

Microsoft Lists integration with Power BI

Подписаться 54 тыс.

Просмотров 75 тыс.

50% 1

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.micros...
Create a list from Excel (video): • Microsoft Lists - crea...
Learn more about Microsoft Lists: aka.ms/MSLists

Опубликовано:

5 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 32

@ekkiwurm7874 3 месяца назад

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.

@KI_Burgberg_DE 2 года назад

And why does the PowerBI data does not update instantly?

@2007pradipta 3 года назад

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

@deniscloutier383 2 года назад

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 ?

@NathanShutes 8 дней назад

Well done, very classy.

@olgamelo4416 2 года назад

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 2 года назад

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

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

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

@selah47 2 года назад

Is there a way to add measures??

@KI_Burgberg_DE 2 года назад

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

@honeybunny7741 2 года назад

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?

@amandas9597 3 года назад

great addition

@LucasSoares-nl6tu 4 месяца назад

Is it possible to insert another list in this powerbi?

@sharensu4398 Год назад

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

@gstdoctor Год назад

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

@christopherrisher7230 3 года назад

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

@chihabaroua7920 3 месяца назад

any solution ?

@krzysztofgorski8075 2 года назад

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?

@j.pablo.r.p7780 2 года назад

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

@krishnaaveersinghhada9220 2 года назад

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

@thomasfoxl 3 года назад

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

@davidcarrico2423 2 года назад

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.