Skip to main content

    Power BI

    New

    Update the import of JSON-files

    Vote (2) 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

    19b65738 8da6-4ede-8479-e1a6b6cea52a 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