Skip to main content

Power BI

Needs Votes

Update the import of JSON-files

Vote (3) Share
Olle Hagelin's profile image

Olle Hagelin on 07 Nov 2018 19:54:31

Still get issues with Extra characters when importing JSON-files from both BigQuary/Firebase and S3 buckets.
This should just work without any issues

Comments (1)
Olle Hagelin's profile image Profile Picture

Olle Hagelin on 05 Jul 2020 23:37:30

RE: Update the import of JSON-files

Issue in more detail is that each row is a json object and not a full json file.
To make it work you have to add a comma at the end of each row and brackets in the beginning and the end.
It is not easy on on millions of rows each day