Forum Discussion
Solved
Properly load a JSON file from a folder as source
Hi guys, I know how to load a JSON file ifself let
Source = Json.Document(File.Contents("\\...\refreshables.json")),
#"Converted to Table" = Record.ToTable(Source),
Value = #"Con...
Your first two steps look correct, but the next should be a navigate step. Do you see something like this at that step?
If so, click on the word "Binary" which should open your file as a JSON type, and then you can use similar steps as your first query from there.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
what folder, file folder or Sharepoitn folder?
In any case, just open a connection to your folder source, then set a filter for the target path, file extension and file name as needed, and then continue with your JSON parse code from there. Check the generated Power Query code, it is pretty straightforward.