Audit Log 'Save Loaded Results' not working properly

[fish3101]

I'm trying to export/save the search results I have generated using the Audit Log Search to monitor Power BI usage. I have set my parameters as desired and have applied a filter on the 'Item' column as I'm interested in usage of a particular dashboard/report/app I have set up. I have a result set with 308 results found. When I use the 'Save Loaded Results' option to export them into Excel for additional analysis, the filtering I had applied is lost and I only get 308 containing all sorts (not specific to the filter I had set).

Seems the filtering is lost on export. Is this a known issue or am I missing a setting somewhere?

[v-ljerr-msft]

Hi @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. 

Regards

[fish3101]

Yes 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.