Forum Discussion

amsrivas's avatar
amsrivas
Icon for Helper IV rankHelper IV
6 years ago

Power 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...
Need Help
CarlosPelay's avatar
CarlosPelay
Frequent Visitor
2 years ago

Hi did you ever find a solution for this?

Conorw15's avatar
Conorw15
Frequent Visitor
2 years ago

I never managed to create the map visual in report builder using the PowerBI dataset. As a workaround I connected report builder directly to the SQL database that I was originally connecting the PowerBI dataset too. From within report builder I wrote some basic SQL scripts that converted the latitude and longitude coordinate columns in the SQL DB to linestrings and points which then allowed me to generate the map visual in report builder. Obviously this workaround might now be applicable in your case as it depends on the original source of data for your PowerBI Dataset.

  • CarlosPelay's avatar
    CarlosPelay
    Frequent Visitor
    2 years ago

    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.

    • Conorw15's avatar
      Conorw15
      Frequent Visitor
      2 years ago

      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.