none
Cannot transform JSON (file or url) to table in Power Query RRS feed

  • Question

  • Hi,

    I am a newbe to Power Query.. 



    I want to retrieve data from an API. In the URL I see all the records (JSON) and if I donwload the file it also automatically creates a JSON. Also if I use this webtool (https://konklone.io/json/) it creates a table with all the data... like I want it.

    But when I import the data I cannot convert it to one big table...  below the steps (i have a dutch configuration)

    So, when I use the Convert-function, I can only create a table with:

    a) the metadata

    b) a specific record



    But not one big table with all the recrods in it... what am i doing wrong?

    Thanks for your reply / help / contribution.

    Yoast



    • Edited by Yoasterboy Tuesday, September 25, 2018 12:53 PM
    Tuesday, September 25, 2018 12:52 PM

Answers