Forum Discussion
Advocate IAudit Log 'Save Loaded Results' not working properly
Microsoft EmployeeHi fish3101,
As far as I know, this is the expected result currently.
1. The 'Filter results' option is only used for viewing the loaded results displayed on the page.
2. The 'Save Loaded Results' option is used for export the loaded results(Based on my test, only 150 results will be loaded each time, we need to scroll down to load more results). For example, if there are 450 items available for the search results, but only 150 results are loaded at the first time. If you use the 'Save Loaded Results' option now, only 150 results will be exported. If you use "Downlaod all results" option, all 450 results will be exported.
In this scenario, I would suggest you add an idea on Power BI Ideas for saving filtered results when exporting the Power BI audit log. :smileyhappy:
Regards
Advocate IYes this is the experience I am having. So I have resorted to downloading the entire result set and using Excel to do the filtering, however when trying to split the AuditData into columns using the comma delimiter I get a mash of data in wrong columns due to some records containing null values for some columns. This then requires a stack of data cleansing before we can do any decent analysis on the data which is way too cumbersome for what we need.
Working with the Audit Logs is very clunky and I would've loved the recent O365 Adoption Content Pack to have included Power BI activity but it doesn't look like it does.