Forum Discussion
Web Text file issues
Hi am trying to hook my power bi to the following weather data
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 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
4 Replies
Anonymous 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.
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
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
Anonymous 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.
