How to Connect Microsoft Lists to Power BI

Поделиться
HTML-код
  • Опубликовано: 6 сен 2024

Комментарии • 33

  • @JessicaDurst-nu2gh
    @JessicaDurst-nu2gh 10 месяцев назад

    This is so amazing thank you, after scouring the internet this IS the best tutorial.

  • @johnpreuss1105
    @johnpreuss1105 3 года назад +3

    Brilliant! Just what I was looking for, thanks! Looking forward to future guides.

  • @waltersjonathan
    @waltersjonathan 2 года назад +1

    Hi - thanks for the example. Is it possible, once everything is published on Teams, to update the data in Germany sales and have that instantly reflected in the PowerBI report without having to open PowerBI, Refresh and Re-publish the data? Thx

    • @AldoJames
      @AldoJames  2 года назад

      I'm not too sure sorry

  • @pallavi_joseph
    @pallavi_joseph Год назад +1

    You are a legend

  • @thomasramsay7076
    @thomasramsay7076 3 года назад +1

    Hi there, iv just start using powerbi.. thanks for the video. Got me almost there. The only issue, I use share point list for a risk log. Each risk item has an assigned owner. Unfortunately when I pull in Sharepoint list it doesn’t pull in the owner correctly. I just get the number ID that sharepoint assigns on this.. any ideas ?

    • @AldoJames
      @AldoJames  3 года назад

      Hi Thomas, love hearing your use case for Bi, unfortunately that’s above my expertise :(

  • @mohitmaddyscorpion
    @mohitmaddyscorpion 2 года назад +1

    nice video! Question: how the content can be modified across excel, list, power bi report. E.g. if i edit the content in the original excel on teams would that automatically reflect across List and power BI report?

    • @AldoJames
      @AldoJames  2 года назад

      If you edit the original excel sheet (or wherever the data is coming from) that will reflect and update in Power BI once you refresh and update the dashboard. Hope this helps :)

  • @davidcarrico2423
    @davidcarrico2423 2 года назад +1

    So I have a question about using PowerBI with Lists and multi-select choice columns. I would like to do a count display of choice types. Lets say I have 5 choices in this choice Column (a, b, c, d, e), but it is multi-select. I have 20 rows, lets say 10 of them have a selection of 'a', and the other 10 have a selection of 'b'. Also, 3 of the 'a's also have a value of 'c' selected, and 2 of the 'b's also have a 'c' selected (for a total of 5 'c's). So total of 20 rows, but across those, there are 25 values. I would like to see a chart that shows counts in columns of 'a' (10), 'b' (10) and 'c' (5). However, when I am playing around with it, it is actually showing 'a,c' and 'b,c' as separate columns so it has 'a' (7), 'a, c' (3), 'b' (8), 'b, c' (2). I am sure there is something simple I can do to address it, but don't know what that is. Is there a way I can address? Thanks,.

  • @lenzypetty9371
    @lenzypetty9371 3 года назад +1

    Really helpful...thanks so much for creating this.

  • @suhaimiabdazais
    @suhaimiabdazais Год назад

    Just subscribed. Looking forward valuable lesson.. Thanks Aldo

  • @davidcarrico2423
    @davidcarrico2423 3 года назад +1

    What licenses do you need to publish to Teams? Can you do that with a PowerBI Pro license, or do you need the Premium license?

    • @AldoJames
      @AldoJames  3 года назад

      Both licenses allow you to publish to teams :)

    • @davidcarrico2423
      @davidcarrico2423 3 года назад +1

      @@AldoJames Hi, I am not sure that is accurate, or may be technically accurate but not practically, as it seems like the party that you are publishing to in teams needs Power BI Pro to view (or higher, such as Premium), unless you publish it to the web, and make it available that way (which has security implications). Are you seeing something different than I am? As it would be awesome if those viewing in teams did not need the Power BI Pro license. Thanks.

    • @AldoJames
      @AldoJames  3 года назад

      Hi David, publishing to a teams site it actually just like publishing to the web. You’ll need the licence to publish but viewers can still see the dashboard you’ve created without needing a pro licence

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

      A year later I now get it that the 'integrate' functionality for PowerBI within lists gives you more sharing capabilities (avoiding licensing costs) than standard PowerBI. 🙂

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

    Buenísimo! muchas gracias

  • @demonfox2882
    @demonfox2882 3 года назад +1

    Great integration, thanks for sharing #empower

    • @AldoJames
      @AldoJames  3 года назад +1

      Thanks for the support :) #engineer

  • @giazzon
    @giazzon 3 года назад +1

    Thank you!

  • @tiatyot
    @tiatyot 3 года назад +1

    cool tips!

  • @javoeira
    @javoeira 2 года назад +1

    Great vid!

  • @meridiangpsllc5110
    @meridiangpsllc5110 3 года назад

    GREAT JOB