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

[WeeS]

I had many perfectly working calls to Destatis Genesis, but this year they changed their API and only allow POST requests. Unfortunately this makes it impossible to use Genesis with PowerQuery without programming and distributing a custom connector anymore. 
I have feature request for a custom connector now live here, although I don't have much hope Destatis would do anything about this. Destatis Genesis - certified connector needed for ... - Microsoft Fabric Community

let
    URL = "https://www-genesis.destatis.de/genesisWS/rest/2020/data/table?" & 
        Uri.BuildQueryString( 
            [ 
                username = "YourUsernameOrToken", 
                password = "YourPasswordOrEmptyWhenToken", 
                name = "61111-0002", 
                area = "all", 
                compress = "false", 
                startyear = "2020",
                endyear = "2023",
                regionalvariable = "",
                regionalkey ="",
                classifyingvariable1="",
                classifyingkey1="",
                classifyingvariable2="",
                classifyingkey2="",
                job = Text.From(false,"en-US"),
                stand="",
                language="de"
            ]),
    Quelle = Json.Document(Web.Contents(URL)),
    Object = Quelle[Object],
    Content = Object[Content],
    Tbl = Csv.Document(Content,[Delimiter=";", Columns=5, Encoding=65001, QuoteStyle=QuoteStyle.None])
in
    Tbl

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