PSC JSON file and Excel PQ

I’m trying to load the PSC snapshot file (JSON format) into Excel Power Query and am getting the error: ‘Unable to connect. We found extra characters at the end of the JSON input’.
I’m hoping to use PQ to merge a list of company numbers with this snapshot to give me the PSC. Is this possible and what is the error?
Any help appreciated.
Thanks