Statistical office (Destatis) connect webservice

[Imperium1]

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 in the past and can help?

Thank you very much!!!

[v-diye-msft]

Hi @Imperium1 

In Power BI, the Web data source type is used for importing a table of data from a Web page. You can take a look at this article: Tutorial: Importing and analyzing data from a Web Page using Power BI Desktop.

If the web page doesn't contain any table data, you only retrieve element data in Query Editor. I would suggest you use XML data source instead of Web URL to retrieve data.

[Imperium1]

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

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]

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.