cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

PBIX for Analyzing Trace

I found an excellent Power BI file that analyzes the Power BI log files for trace diagnostics.  However, I noticed this one is over a year old and has some errors (probably from PBI changes).  I wondered if someone had adopted this or knows of another one?

 

https://ruiromanoblog.wordpress.com/2016/01/08/power-bi-desktop-trace-logs-analyser/

 

Thanks for any help,

Ward

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: PBIX for Analyzing Trace

Hi @wmorris20,

 

I haven't' found any similar file which the same function. You can use the sample file, it can runs without any compatibility issues.
Based on test, I found the sample file is a custom query used to merge and expand the log files and display the specify columns.

 

You can follow below steps to use it:

1. Download and open it.
2. Click edit queries enter to query editor.
3. Use your path of trace folder to replace the text stored in VAR_LogFolder variable.
4. Close and apply the change.
5. Refresh at report level.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper II
Helper II

Re: PBIX for Analyzing Trace

There are a couple of problems I have found with it. An early column split by colon does not work all the time, because the entries are inconsistent. Occasionally, you'll get a type of "{Start". Additionally, the JSON that gets expanded into columns explicitly names the columns to split, but there are many more than it will display. For any testing, I would recommend a lot of logging first with multiples types of connections. The logging varies quite a bit.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors