Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Working with CSO / Open Data

Options
  • 24-05-2021 2:39pm
    #1
    Diceicle
    Registered Users Posts: 1,799 ✭✭✭


    Has anyone worked with the Gov Open Data portal and the JSON-Stat files therein?
    its a new area for me.
    I was/am looking to do a little side-project where I would take some data from the open data portal and visualize it in MS Power BI. Had (naively) expected it to be straight forward but not so, it seems.
    Power BI doesn't like the JSON Stat format.

    Do I have to ETL the JSON into a table and read it into Power BI from there?


Comments

  • Options
    #2
    igCorcaigh
    Moderators, Recreation & Hobbies Moderators Posts: 11,355 Mod ✭✭✭✭igCorcaigh


    I think Eurostat also uses the JSON stat format.

    Does this article help?
    I have never used Power BI (is it free to use?)

    https://eriksvensen.wordpress.com/2019/01/09/guide-how-to-import-data-from-eurostat-directly-into-powerbi/


  • Options
    #3
    Diceicle
    Registered Users Posts: 1,799 ✭✭✭Diceicle


    Thanks, I'll check that out.
    Yes, power BI, the Desktop version is free.
    My understanding is their licencing kicks in if you want to share dashboards and workspaces between teams.
    It a very robust program.


  • Options
    #4
    dotsman
    Registered Users Posts: 3,636 ✭✭✭dotsman


    Power BI should be able to handle JSON.

    https://www.mssqltips.com/sqlservertip/4621/using-power-bi-with-json-data-sources-and-files/

    Not very familiar with the various Data tools, but any that doesn't work brilliantly with JSON should be ignored.


  • Options
    #5
    igCorcaigh
    Moderators, Recreation & Hobbies Moderators Posts: 11,355 Mod ✭✭✭✭igCorcaigh


    dotsman wrote: »
    Power BI should be able to handle JSON.

    https://www.mssqltips.com/sqlservertip/4621/using-power-bi-with-json-data-sources-and-files/

    Not very familiar with the various Data tools, but any that doesn't work brilliantly with JSON should be ignored.

    Json stat is a different format though, isn't it?


  • Options
    #6
    dotsman
    Registered Users Posts: 3,636 ✭✭✭dotsman


    igCorcaigh wrote: »
    Json stat is a different format though, isn't it?

    Never worked with it, but assume it is still just JSON (albeit a large & complex structure, no doubt).

    But, given the rise of JSON over the past decade as the standard way to move/describe data, I'd be very concerned with a data tool that can't easily navigate/interpret it.


  • Advertisement
  • Options
    #7
    Diceicle
    Registered Users Posts: 1,799 ✭✭✭Diceicle


    igCorcaigh wrote: »
    Json stat is a different format though, isn't it?

    It seems to be different. Power BI is not accepting it.


  • Options
    #8
    dotsman
    Registered Users Posts: 3,636 ✭✭✭dotsman


    Just did a quick google, and yeah, Power BI seems to have problems.

    Tableau does work with it though if you want to try that.

    Or, if you have to stick with Power BI, you can try convert it and then feed in to power BI: https://json-stat.org/tools/


  • Options
    #9
    Diceicle
    Registered Users Posts: 1,799 ✭✭✭Diceicle


    Thanks Dotsman.

    Appreciate you looking into that.
    I've used Tableau previously but at present Power BI is the tool that is gaining traction in my organisation so I think i'll have to stick with that.
    I'll try the conversion method as you suggest.


Advertisement