WKT polygon - coordinates are too long for insert into Excel cell

[Mila22]

Hi,

I'd like to ask for your help. I need to insert WKT polygons of certain regions (regions, districts,...) into the IconMap visual.
Usually I put the data about the given polygons into the related Excel table and attach it. The problem is that the polygons I want to use now are about six times longer than the number of characters that can fit in one cell in Excel. What to do? Have any of you solved a similar problem? Do you have any ideas? The only solution I can think of is to split the data into multiple rows in Excel and "virtually" join them via VBA, for example.

M.

[msmith61 · Accepted solution]

hi @Mila22 ,
I have just had this same issue and I think I have a solution, after quite a lot of Googling (I find trying to ask the correct question is always the hardest thing!) and lots of playing around with word, Excel and SQL. The best way is to split WKT into multiple columns and then use a DAX measure to concatenate these back together and use that DAX in your visual. I used Word for counting characters, excel to export WKT from QGIS and then sql by using a case statement to create split columns for those wkts with character count over 32,766 which is a limit in PowerBI when I import from Excel.

Hope this helps

Matt

[Mila22]

Hi Matt,

thank you for your message. I ended up using this tool https://mapshaper.org/ and simplified the polygon boundaries. However, this is not always possible as accuracy suffers. Then your description would be the solution. 

Thanks!

Mila