Forum Discussion
amsrivas
Helper IV
Helper IVPower BI Report Builder map with Power BI dataset source
Hi Folks!! I have to create Power BI BUILDER REPORT with map visual. Source for the Power BI Builder Report is Dataset generated by another Power BI Desktop report and placed at Power BI Serv...
Hi Thanks for your response.
Would you be able/willing to post relevant portions of those scripts to convert coordinates to points in Report Builder - or point me to an online resource. I'm not sure I would know how to do that.
Thanks.
Hi I found this online resource very useful to convert columns of latitude and longitude in my SQL database to WKT Points and Linestrings: Introduction to SQL Server Spatial Data - Simple Talk (red-gate.com)
I dont think my exact code would be that helpful given that its very specific to my particular circumstance. Also just to note I used a connection type of Microsoft Azure SQL Database as the Data Source.