Forum Discussion
Json-Stat
Hi
how to link json-stat like this?
Json-stat is beautiful for open data but i can't link them to Power BI....
many thks
6 Replies
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,
LydiaIt 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
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
