Web Text file issues

[the_suite_life]

Hi am trying to hook my power bi to the following weather data

https://www.metoffice.gov.uk/pub/data/weather/uk/climate/datasets/Tmax/ranked/England_SE_and_Central...

The issue i am having is what is the best way to get this into power bi. Whatever format i choose from web to text it comes in a format that doesnt allow me to put it into a table.

Any help would be great?

[parry2k]

@the_suite_life awesome, good to hear. Cheers!!

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[the_suite_life · Accepted solution]

@parry2k Fixed the issue, i combined the year and temp together. Then once completed i split by delimited. This got around the max rows limit error

[parry2k]

@the_suite_life use Extract by example and that will do it

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[the_suite_life]

@parry2k issue is, you hit the limit of maximun size of table due to how many columns there are. Can only get up to November