Forum Discussion
Imperium1
6 years agoFrequent Visitor
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...
WeeS
1 year agoNew Member
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