The 2nd Edition of #25daysofdaxfridays challenge is here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

Print

Decompress GZIP files using Power BI and get access to Eurostat data

In today’s video, I will show you how to access Eurostat open data using power bi. Most data is stored in GZIP files and you need to know how to decompress GZIP files to be able to get the data.
I will show you two methods in this video.

Table of contents:

00:00 Intro & use case explanation
01:00 Get the web link into the web connector
01:30 Solution 1 – Open As (Binary)
02:30 Solution 2 – Decompress using function

Watch the tutorial:

Decompress gzip files using Power BI and get access to @EU_Eurostat data.

Links to the mentioned resources

Link to Eurostat data portal: https://ec.europa.eu/eurostat/data/da…
Link to disable auto date/Time: https://www.youtube.com/watch?v=d4yAz…

Was this helpful?

Reader Interactions

Let us know your thoughts...

Table of Contents