Forum Discussion

Marghe's avatar
Marghe
Frequent Visitor
8 years ago

JSON to Power BI table

Hello,    I am attempting import JSON data from online APIs into Power BI. It all goes rather smoothly until I get to this point:      when I click to expand the 'data' column, Extract Val...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Marghe,

 

What data you stored in column as the formula of list ?

Can you l please share some detail contents of your data and the expected result.

 

REgards,

Xiaoxin Sheng

  • Marghe's avatar
    Marghe
    Frequent Visitor
    8 years ago

    Hi Anonymous!

     

    thanks for your reply! the data I'm trying to extract is the one you can find in this link Data.

    When imported into power bi through APIs, the 'Data' column list should contain all columns to the right of the 'value' column in the excel spreadsheet.

     

    Thank you for your help!

     

    Marghe

     

     

     

     

     

     

    • zoloturu's avatar
      zoloturu
      Memorable Member
      8 years ago

      Marghe,

       

      Please provide full URL to your JSON file path here. I don't see where is it on link you've provided. I will check it. It is good to check if rows which have Data equals Record are needer or maybe you can exclude them.

      • Marghe's avatar
        Marghe
        Frequent Visitor
        8 years ago

        zoloturu

         

        here is the APis path to my JSON file data.

         

        Thank you