cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kopek
Helper III
Helper III

Performance Analyzer export to excel

Hi,

 

I am just wondering how i can export performance analyzer data to excel.

I have tried to export as json, connect to power bi, and then exported to excel,but my json does not contain Duration (ms) column,,, only evenst start and events end columns... is that right ? 
How to approach that to have duration values available as well ? do i have to prepare a measures or is there easier way to xptrac those data in excel format ?

 

Thanks in advance!

3 REPLIES 3
v-henryk-mstf
Community Support
Community Support

Hi @Kopek ,

 

Export date gives you the ability to export entire tables from your data model to either CSV files or to SQL Server.

vhenrykmstf_0-1630056078455.png

For more details, you can read related document:

Output Modes (daxstudio.org)


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

nvprasad
Solution Specialist
Solution Specialist

Hi

 

I use "DAX Studio" not only to export data into excel but also performance tuning.

 

Just explore "DAX Studio".

 

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

Hi,

 

 

I have download the DAX Studio, but i am not able to eport data to excel, it's just exporting the code, whereas i need to export data highlighet in yellow, so vizualization name and duration (ms), can you guide me how to do that, please:

 

 

Perf.pngPerf2.png

 

 

 

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.