Forum Discussion

MarianneElver's avatar
MarianneElver
Helper III
10 years ago

Load all records and lists from json file

I have a JSON file containing professional data with a number of records and lists, and I only seem to be able to load one table at a time, for each query. It looks a bit like this when loading the fi...
Cubist's avatar
Cubist
Advocate II
9 years ago

Since this is the top google result, and not updated, note Power BI has a default JSON document connector you can use that to import JSON data.

 

To use JSON from a file in Power BI

  1. Choose Get Data > choose More... > choose "JSON" > choose the JSON file
  2. You should see a "List" of "Records" in Power BI, don't panic
  3. Select the list, choose Convert to Table
  4. On the individual column headers, look for a splitter icon.  Choose split to expand fields.