Forum Discussion

dlazarov's avatar
dlazarov
New Member
10 years ago

Office 365 Audit Log

  Hi   I found this article https://support.office.com/en-us/article/Search-the-audit-log-in-the-Office-365-Protection-Center-0d4d0f35-390b-4518-800e-0c7ec95e946c?ui=en-US&rs=en-US&ad=US   Is t...
Need Help
dgrant's avatar
dgrant
Advocate II
9 years ago

I agree it would be very helpful to have access to the O365 Audit Logs as a data source in PowerBI.    I would like to create a custom dashboard to check how Sync is working for OneDrive for Business.  Exporting the audit trail and then generating the report seems a bit silly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    I agree, currenly I can't see a way of integrating the Office 365 Logs into Power BI in a automated fashion.

    Even maybe using MSFLOW etc to automate.

     

    This is becoming a requirement at my workplace where management want to track Power BI usage and adoption.

     

    Regards, Drickus

    • shietpas's avatar
      shietpas
      Frequent Visitor
      9 years ago

      You can automate the export of the O365 Audit Log, including Power BI Activities, using PowerShell.  You can then automate the regular execution of PowerShell.  I currently export to Azure Storage and use Power BI to import all exported activities for consolidated reporting.  This also has the advantage of retaining more than 90 days history currently supported in the audit logs.

      • davidlec's avatar
        davidlec
        New Member
        8 years ago

        I have just been asked to almost exactly this - export the O365 SharePoint online logs monthly using PowerShell. Are you able to share your PowerShell script that does this?