Forum Discussion

Frequent Visitor

5 years ago

Solved

Unable to Import EIA Data - Bulk Data File - Petroleum

Hi There, I'm interested in importing Petroleum Data from the EIA. https://www.eia.gov/opendata/bulkfiles.php from here I downloaded the petroleum data: http://api.eia.gov/bulk/PET.zip The ...

Need Help

Tips and Tricks

pwares
5 years ago
Thanks for your response, unfortunately I received errors when trying your method:

Specifically, the Power BI error mentioned: Unable to connect, we encountered an error while trying to connect, Details: "We found extra errors at the end of JSON input"

As a result, I searched this forum for a similar error message, and came across this tip:

BNajlis
New Member
Re: We found extra characters at the end of JSON input.

‎08-24-2016 01:10 PM
Found the same issue when trying to load a JSONL file (http://jsonlines.org/). To solve it, I ended up importing it as a text file (which takes one record per line) and then using the Parse function in PowerQuery to parse the JSON in each line.

Eventually I was able to get a successful result by using the Parse Function

pwares

Frequent Visitor

5 years ago

Thanks for your response, unfortunately I received errors when trying your method:

Specifically, the Power BI error mentioned: Unable to connect, we encountered an error while trying to connect, Details: "We found extra errors at the end of JSON input"

As a result, I searched this forum for a similar error message, and came across this tip:

Found the same issue when trying to load a JSONL file (http://jsonlines.org/). To solve it, I ended up importing it as a text file (which takes one record per line) and then using the Parse function in PowerQuery to parse the JSON in each line.

Eventually I was able to get a successful result by using the Parse Function