Forum Discussion

stuartridout's avatar
stuartridout
Icon for Microsoft rankMicrosoft
May 26, 2020

Teams live event log analysis Power BI

I'm seeing a huge increase in the number of live events that my customers have been using either internally for their employees or externally with customers and suppliers. They have been looking for ...
analytics
microsoft teams
power bi
AKSINGH84's avatar
AKSINGH84
Copper Contributor
Oct 03, 2020

stuartridout - Thanks for article ,very informative and useful. I have one question though , let's say i am organizing 5 live events in a day and want to get the info from all the events directly into the Teams log Event Power BI report ,without any manual activity ( for e.g. calling any API or after initial setup for first event , log files are getting updated automatically for subsequent events). Is it possible to achieve ? 

  • stuartridout's avatar
    stuartridout
    Icon for Microsoft rankMicrosoft
    Oct 03, 2020
    Unfortunately you can’t do this programmatically at the moment.
    • AKSINGH84's avatar
      AKSINGH84
      Copper Contributor
      Oct 03, 2020

      stuartridout Thanks for quick update. so currently optimized way is to ask Teams Live Event Producer to consolidate the Event logs file after each Event and upload it at some SharePoint Site Folder . From SharePoint Folder Power BI Event report can read the updated data  using scheduling or some other similar mechanism. Your thoughts!!!!

      • stuartridout's avatar
        stuartridout
        Icon for Microsoft rankMicrosoft
        Oct 03, 2020
        Possibly with some clever scripting. The report needs to be able to consolidate the attendance logs and the Q&A logs together as well as add in some metadata that is not in the report such as date, time and title of the event. This is why the process is to manually combine.

Resources