none
using Excel REST APIs sharepoint online in power bi - Reporting Audit Logs using Power BI

All replies

  • Hi,

    You can save the Audit Logs Excel files into a document library, then use the Excel REST API below to get the data:

    https://<SharePointOnlineSite>/_vti_bin/ExcelRest.aspx/<DocumentLibrary>/<FileName>.xlsx/Model/Ranges('<RangeName>')?$format=atom

    Excel REST API in SharePoint Online

    https://blogs.office.com/2013/12/17/excel-rest-api-in-sharepoint-online/

    About the Power BI issue, I suggest you post it to Power BI Forum, you will get more help and confirmed answers from there.

    Best Regards,

    Dennis


    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Thursday, August 25, 2016 8:04 AM
    Moderator