March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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!!!
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.
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:
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
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
114 | |
76 | |
57 | |
52 | |
44 |
User | Count |
---|---|
165 | |
116 | |
63 | |
57 | |
50 |