Outputting 2.0GB spatial files to PowerBI

I have consolidated a large database of relevant location data with polygons, and intend to upload to PowerBI. I have the core output saved as a .yxdb file but need a new file type to output into PBI. My file is greater than 2GB so shapefiles won't work. Maybe I can split the output into a couple of shp files but dont really want to stack them in PowerQuery (I try to avoid PQ at all costs - but if it is the only way I am fine with it).

I tried outputting as geojson but can't seem to get it to work.

PS: I am using the reporting tools for early visuals, but the powers that be want an "interactive and cool" tool.

Any ideas are welcome!

Thanks!

Workflow

Output

Power BI

Accepted answers

jfha97

@caltang I tried running it and apparently PowerBI does not like Alteryx SpatialObj data type so it throws an error.

So to anyone still needing a solution, your best best is to split the stream if greater than 2GB into a couple of .shp files and union back with PQ.

All comments

caltang

Have you tried a direct PowerBI output, skipping the YXDB portion? https://help.alteryx.com/current/en/designer/tools/connectors/microsoft-power-bi-output-tool.html

jfha97

@caltang thank you so much for your response.

Interesting idea, I have not tried it but I will and will come back to you with results.

Also for context, was able to refine my data before the spatial match portion of the workflow and was able to get the file down to 1.5GB so will try the .shp output. However, for anyone still looking for a solution, please look below in the thread to see if the PowerBI output worked.

jfha97

@caltang I tried running it and apparently PowerBI does not like Alteryx SpatialObj data type so it throws an error.

So to anyone still needing a solution, your best best is to split the stream if greater than 2GB into a couple of .shp files and union back with PQ.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703