Hello,

I’ve used FME Desktop in the past to convert a planning applications shp (points) file to a csv file for use in PowerBI. To get data working in PowerBI certain set fields need to exist (in the output csv) that are not in the planning apps shp file: Name, Icon and Color (sic).

This is where Name is typically the main reference value in the dataset (e.g.: the site name or an planning ID), Icon is the name of the icon type to be used in PowerBI (e.g.: hexagon-thick) and Color is the colour PowerBI uses for the icon (e.g.: #8B0000).

So, when creating this output csv for use in PowerBI I read in the shp, connected to a AttributeReprojector to convert to LL-WGS84 (because the source shp was in EPSG:27700 and PowerBI requires LL-WGS84). I then connected to an AttributeManager where I 1) renamed the Planning application number field to 'Name', 2) added a new field called 'Icon' (with the value of ‘hexagon-thick’ for all records, 3) added a new field called 'Color' with a value of #8B0000 for all records.

All that worked fine. The output csv was exactly what the PowerBI user needed. 

But that was a point dataset. I now need to prep a polygon dataset for PowerBI. Does this still need a) reprojection to LL-WGS84? (I assume it does), b) a new field called Color, and c) a new field that is the equivalent of Icon for polygons. I say equivalent as I assume I wouldn’t need icon as it’s a polygon dataset, not a point dataset. So, if not Icon, then what should that new field be called?

Also, I understand that PowerBI would need it as a topoJSON. Could someone confirm that, please.

Thanks,