Forum Discussion

Ghibbli's avatar
Ghibbli
Frequent Visitor
8 years ago

Json-Stat

Hi how to link json-stat like this? http://www.mc.camcom.it/uploaded/linked-open-data/Stock-Imprese-Attive-Italia.json?0.2621881899390053   Json-stat is beautiful for open data but i can't link t...
Need Help
Tips and Tricks
Tutorial Requests
Ghibbli's avatar
Ghibbli
Frequent Visitor
8 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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