load performance analyzer data(json) into power bi

[Anonymous]

Hi, I am trying to load the json content generated from Power BI Performance Analyzer. However, when i load the file all I am seeing some data which is not useful. for ex. I want to see the actual DAX queries/measure used etc. I dont see that getting loaded. 

Anyone out their has experience on how to load all this data into a table in Power BI? I am fine to first import into a db table/excel and then import it to Power BI.

Appreciate your help and time

Thanks,

SN

[mwegener · Accepted solution]

Hi @Anonymous 

try this..

Navigate into the list

Convert the list to table

Expand the column (press on "load more" to get all columns)

Expand the metric column (press on "load more" to get all columns)

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[mwegener]

Hi @Anonymous ,

did you solve your problem?

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.