Localo seo tool - free rank checker data integration issue in Map Visual?

[localoseo]

Hi everyone,

I'm hoping to get some advice on a common issue I'm facing with visualizing geographic data in Power BI Desktop.

I'm working on a report to analyze the performance of several local business branches. A key part of this is to visualize our ranking in different service areas on a map. The basic Bing map visual is okay for plotting locations, but it doesn't really give me the detailed, grid-style view I need to see how we rank street-by-street.

I've been exploring external tools to get this level of geographic detail. A colleague recommended a localo seo tool - free rank checker to generate heatmap data of our local search rankings. The idea is to export this ranking data (it comes as a CSV with latitude, longitude, and rank score) and then create a rich heatmap visual in Power BI.

This is where I'm stuck. When I import the CSV and plot it on the map, the data points don't seem to layer correctly to create a heatmap effect. It just looks like a series of scattered dots.

My question is: What is the best practice for integrating this kind of granular, grid-based location data into Power BI? Is there a specific custom visual that’s better for this than the standard map? Or am I missing a step in Power Query to properly structure the data?

For context, the data I'm trying to visualize is similar to what you can see in the public-facing version of the tool. I'm trying to build something similar to their grid view inside my Power BI dashboard. You can see an example of the geogrid data I'm trying to replicate here.

I feel like this must be a common problem for anyone trying to visualize hyper-local performance data. Any pointers or examples would be hugely appreciated!

Thanks in advance!

[v-dineshya · Accepted solution]

Hi @localoseo ,

Thank you for reaching out to the Microsoft Community Forum.

You are importing a CSV with latitude, longitude, and rank score into Power BI, but the default Bing Map visual only shows scattered dots, not a heatmap. You want a grid-style heatmap similar to Localo’s geogrid view.

Please follow below steps.

1. Created sample data with Latitude, Longitude, and Rank columns, imported into Power bi.

2. Go to Visualizations --> Add Azure Maps. Drag Latitude and Longitude into respective fields. Drag Rank into the Size field.

3. In the Format pane, toggle Heatmap to ON. Adjust Radius, Intensity, Color gradient and Zoom levels for visibility.

Please refer below output snap and attached PBIX file.

Please refer below link.

Icon Map Pro

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh

[v-dineshya]

Hi @localoseo ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

[v-dineshya]

Hi @localoseo ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

[v-dineshya]

Hi @localoseo ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

[Royel]

Hi @localoseo  you can try this custom HeatMap Visual 

https://weiweicui.github.io/PowerBI-Heatmap/ 

Thanks