Json-Stat

[Ghibbli]

Hi

how to link json-stat like this?

http://www.mc.camcom.it/uploaded/linked-open-data/Stock-Imprese-Attive-Italia.json?0.262188189939005...

Json-stat is beautiful for open data but i can't link them to Power BI....

https://json-stat.org/

many thks

[v-yuezhe-msft]

@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

[Ghibbli]

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" : "fabio.castelletti@mc.camcom.it",
"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

http://www.mc.camcom.it/uploaded/linked-open-data/Stock-Imprese-Attive-Italia.json?0.755972683596139...

[v-yuezhe-msft]

@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

[Ghibbli]

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....

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

[Ghibbli]

this is an output example

http://json-stat.org/format/viewer/?uri=http%3A%2F%2Fwww.mc.camcom.it%2Fuploaded%2Flinked-open-data%...

[v-yuezhe-msft]

@Ghibbli,

I don't think that you can get the above result in Power BI Desktop. When connecting to your JSON file in Power BI, we can only extract values wrapped in the List/Record of the JSON file.

Regards,
Lydia