Eurostat data in Power BI with a few clicks (and it auto-refreshes!)

Join this channel membership to get access to all the recorded bites as they become available:

Check the blog post for more info:

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen

#CURBAL #SUBSCRIBE

[sugartraders]

Just so exciting. I saw the notice on Eurostat about this and I thought, ok, that's going to take me ages to work out. But it's not, it's actually quite easy! Thank you very much for sharing and showing me how. 🎉📈✨

[krzysiekhyla]

Amazing Curbal! Thanks a lot for showing this step by step! How do I pull dimensions like GEO or TIME via SDMX to create a data model in Power BI?

[Zunidrap]

This is incredible! Thank you for sharing. 😃

[patitopototo]

Is it possible to do the same thing in Power Query? I can´t seem to find if power query can open SDMX, it all points towards power B.I.

[victormorecoloma]

Sensacional, Ruth! You're the best!! :))

[borisarnold]

Hi Thank you very much for the great video. Quick question. I would like to use the steps outlined in the video for the dataset EU trade since 2002 by HS2-4-6 and CN8 (new content) with the code: ds-059322. I get an error message. Did you come across a similar issue for certain ESTAT codes? Thank you in advance for the help.

[viktorasgolubevas]

Great news and tips for data and "few click" lovers :)
Thanks a lot for sharing! Amazing!

[bakalogatos]

That's some great news :)
Can we have auto refresh in Power bi Report Server as well?

[julianemota]

Hi Consuelo, I am facing a challenge with Power BI and desperately need the help of someone who really knows Power BI. This is my problem:

I work in the insurance industry and the products we sell are policies. Several insurers can participate in a single policy and therefore the price for a policy is the sum of the individual prices charged by each insurer that takes up that policy. If I look at the price of a policy when I consider all insurers, it would be something around a million ($1, 000, 000), however, if I filter my data for just one participating insurer, then the price is much smaller, that is, say 100K ($100, 000).

I would like to create a chart that on the X-axis display premium buckets and on the Y-axis displays bars counting the number of policies which premium falls in each of those buckets. The thing is, sometimes I will not not filter my data for any specific insurer and as a result the premium for each policy is the total premium for all participating insurers combined. this means that premium for each policy is high, often above $1m. However, there will be instances when I want to filter the data for just one single insurer, and therefore, the premium for each policy is limited to the premium charged solely by the insurer being considered. In this case, the premium for each policy would be around $100K. I would like the premium buckets in the X axis to be adjust to reflect the average policy premium once a selection is made for the number of insurers to be considered.

I have already checked this YouTube inside and out but did not find a solution. Can you help me to solve this? What do I need to do for you to read my comment and hopefully, help me????

Please Consuelo, help me!!!