Statistical office (Destatis) connect webservice

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.

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