cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shannonlowder Frequent Visitor
Frequent Visitor

power bi audit log

Rui Romano has a great tool over at https://ruiromanoblog.wordpress.com/2016/01/08/power-bi-desktop-trace-logs-analyser/ to anlyzing your Power BI Audit logs to try and figure out why your refreshes are slow.  There is only one problem. I can't seem to find any documentation for translating the actions into english, so I can understand what the problem is and how I can work to resolve the problem.

 

Does anyone know where I could find translations for RemoteDocumentEvaluator, SimpleDocumentEvaluator, and RemotePageReader along with their child actions?  I've got a small excel file (<500 rows) being used to filter a small (<2M row) Tabluar Model for a proof of concept. When I change to a SQL table, I get similar results as Excel. It takes about 3.5 minutes to read the data.

 

Only 15 - 20 seconds of that time is reading the Tabular model. When reading a SQL table, that SQL read takes 0.0 seconds. When reading the excel file, that too takes 0.0 seconds.

 

The major waits are:

  • TracingMashupEvaluator/Evaluate 
  • RemoteDocumentEvaluator/Service/OnBeginGetResult, GetResult
  • SimpleDocumentEvaluator/GetResult
  • DocumentEvaluator/GetResult
  • RemotePageReader/RunStub
  • PBI.Dashboard.RootSession

 

5 REPLIES 5
Vicky_Song Established Member
Established Member

Re: power bi audit log

@shannonlowder, I'm trying to involve other senior engineers to take a look at the issue you raised. I will post back for any updates.

shannonlowder Frequent Visitor
Frequent Visitor

Re: power bi audit log

If the senior engineers have any documents on the audit logs, that would be a great help here.  I'm really looking for a deeper understanding of Power BI Internals and the mashup workers.  If I could understand these action descriptions, I think that would answer why the performance is so bad in this one case.

 

I have noticed that it appears that for each data pull the mashup appears to process that "file" of data three to five times. That seems odd to me. It could be various steps in compressing that data to package it up into the resulting report file.

 

Thanks for anything you can share!

Vicky_Song Established Member
Established Member

Re: power bi audit log

@shannonlowder, I'm still in the progress to involve other engineers. You can also submit one document request on the Ideas forum here: https://ideas.powerbi.com/forums/265200-power-bi-ideas 

Highlighted
Vicky_Song Established Member
Established Member

Re: power bi audit log

@shannonlowder, I got updates from engineer from PG team:

"Those traces files are collected on the customer machine and should be provided to the engineering team to help troubleshoot issues. The engineering team does not expect customers to look at this data and do not plan to educate customer on how they can do this".

Karthi Frequent Visitor
Frequent Visitor

Re: power bi audit log

Is there a way we can view the filters selected by a user in the audit log???  Does audit log gets the filters selected on a dahboard or a report??? 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 59 members 1,213 guests
Please welcome our newest community members: