Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

load performance analyzer data(json) into power bi

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

 

 

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

2 Replies

  • mwegener's avatar
    mwegener
    Most Valuable Professional

    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's avatar
      mwegener
      Most Valuable Professional

      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.