Forum Discussion
Json-Stat
Ghibbli,
You can use JSON connector in Power BI Desktop to connect to the JSON file, and extract data from record and list in the imported query.
Regards,
Lydia
- Ghibbli8 years agoFrequent Visitor
It doesn't work
Json-stat is a mix rdf+json
So you'll have only data, not record or structure. An example:
{"Monthly-Data-2009-Today":{ "class":"dataset", "href":"http://www.mc.camcom.it/uploaded/linked-open-data/Stock-Imprese-Attive-Italia.json", "label":"Stock Sedi di Impresa Attive in Italia per Territorio (Province e Regioni), Settore di Attività Economica (Ateco 2007) e Tempo (Frequenza Mensile, Valori fine periodo)", "note" : [], "source":"Elaborazioni CCIAA di Macerata su dati InfoCamere", "updated":"6 dicembre 2017", "extension" : { "contact" : "[email protected]", "metadata" : [ { "title" : "Open Data Explorer - Camera di Commercio di Macerata", "href" : "http://www.mc.camcom.it/P42A784C90S39/open-data.htm" }, { "title" : "Indicatore/Misura", "href" : "http://www.mc.camcom.it/uploaded/linked-open-data/data/indic.rdf" }, { "title" : "Territorio", "href" : "http://www.mc.camcom.it/uploaded/linked-open-data/data/geo.rdf" }, { "title" : "Settore di Attività Economica", "href" : "http://www.mc.camcom.it/uploaded/linked-open-data/data/ateco2007.rdf" }, { "title" : "Tempo", "href" : "http://www.w3.org/2006/time.rdf" }, { "title" : "Licenza", "href" : "http://creativecommons.org/licenses/by/4.0/" } ] }, "value":[878089,878911,879762,879262,878346,877616,876598,875251......................url
- Anonymous8 years agoNot applicable
Ghibbli,
I make a test using a small JSON file, could you please post the expected result after importing the JSON file to Power BI Desktop?
Regards,
Lydia- Ghibbli8 years agoFrequent Visitor
Your test is correct; i'm newbie
this is an output DEMO http://www.mc.camcom.it/uploaded/Allegati/Promozione/Charts/Open-Data-Dataset.htm?url=http://www.mc.camcom.it/uploaded/linked-open-data/Stock-Imprese-Attive-Italia.json&r1=1&c1=3
but if you connect json-stat to power bi, it doesn't work.
http://www.mc.camcom.it/uploaded/linked-open-data/Stock-Imprese-Attive-Italia.json
probably power by doesn't understand RDF link like this in json-stat file
"title" : "Indicatore/Misura", "href" : "http://www.mc.camcom.it/uploaded/linked-open-data/data/indic.rdf"
Please consider Eurostat publishes alla open data info in this format
http://ec.europa.eu/eurostat/web/json-and-unicode-web-services/about-this-service