Forum Discussion

Imperium1's avatar
Imperium1
Frequent Visitor
6 years ago

Statistical office (Destatis) connect webservice

Hi, has anybody experience in connecting the german statistical office (Destatis) with Power BI? Destatis offers a webservice but I can not connect to this service ... Has anybody tried to do that...
Need Help
Imperium1's avatar
Imperium1
Frequent Visitor
6 years ago

Hi Dina Ye,

 

thank you very much for your help 🙂 The link was very interesting ...

 

The webpage I would like to get data from is:

https://www-genesis.destatis.de/genesis/online/data?operation=abruftabelleBearbeiten&levelindex=1&levelid=1575016528135&auswahloperation=abruftabelleAuspraegungAuswaehlen&auswahlverzeichnis=ordnungsstruktur&auswahlziel=werteabruf&code=61311-0016&auswahltext=&werteabruf=Werteabruf

 

These are values from the statistical office in Germany showing ship transport prices ...

 

On the page there is a table and I tried to load it into Power BI (as also described in your link). Unfortunately the table is not loaded:

 

 

Any idea what went wrong?

 

Thanks again,

 

IMP

 
  • TiGri's avatar
    TiGri
    New Member
    4 years ago

    Hi  Imperium1 ,

     

    I have managed to get data from Destatis via API into Power Query by usind parts of this code;

    https://www.yodabi.com/destatis-genesis-and-power-bi/

    as well as try and error und reading the GENESIS Webmanual. 

     

    Did you find also a solution so far? If yes I would be highly interested because mine is only 80% of what I need.