Processing detailed WKT files for Icon Map: Getting around the text character limit in Power BI

Sometimes we want to display detailed spatial files in Power BI using WKT text strings in the Icon Map custom visual… BUT Power Query has a text character limit of 32,766 characters per data point! In this video blog I walk through some Power Query and DAX magic to split up our WKT text string and then stitch it back together using CONCATENATEX. I also go over a very frustrating ‘gotcha’ where Power BI removes the lagging spaces in our text string on import (which causes errors in our WKT file) and how to resolve it. I hope this helps you have fun exploring maps in Power BI. If you're keen to explore the Power BI report and read the step by step instructions with links, then check out the Power BI report and blog here: www.discoverei.com/blog/powerbi-processing-detailed-wkt-strings-for-icon-map If you're interested in learning more about Power BI applications for the environmental industry, then head on over to our website for project examples: https://www.discoverei.com/, take a look at our exciting training courses: https://www.discoverei.com/training, check out our blog posts: https://www.discoverei.com/blog or join in the fun with the community at our #PowerBI4Enviros Meetup group: https://www.meetup.com/en-AU/powerbi4enviros/ This video is part of DiscoverEI's Maps for Power BI series, please subscribe for more videos about maps. Thanks for watching and have fun exploring mapping techniques for Power BI!