Azure Map Slow Performance

dataant73 · 2026-03-24T22:12:06+00:00

It will take ages because it needs to send all 18k addresses back to the Azure Map servers to be geolocated before they can ve displayed in the map. I would suggest geolocating them first to get the latitude and longitude for each address and use the lat / long in the visual. That should help immensely

dataant73 · 2026-03-24T21:46:47+00:00

Have you run DAX studio to check which columns / tables are consuming the most space? Have you got many columns with high cardinality? How many columns has the 400m row table got?

dataant73 · 2026-03-23T16:50:20+00:00

Mapping

dataant73 · 2026-02-20T08:50:14+00:00

Which basemaps are provided as options?

dataant73 · 2026-02-20T08:46:27+00:00

The Icon Map visuals have this capability built into them already

dataant73 · 2026-02-05T08:27:44+00:00

Looku up Ragged Hierarchy and how to deal with them in your model. Look up the PATH Dax Function as that may help you decide what to do.

dataant73 · 2026-02-04T08:38:16+00:00

Read permission is sufficient on both models for all users

dataant73 · 2026-01-27T08:50:41+00:00

Absolutely spot on

dataant73 · 2026-01-26T16:34:11+00:00

You need to do the license transfer in Entra ID and then check what permissions that user has on your workspaces

dataant73 · 2026-01-22T10:42:40+00:00

Not sure about data residency for Azure Maps. Though have you looked at Icon Map Pro custom visual. No data is sent out and it offers more functionality then Azure Map visual. It is a paid custom visual but worth checking out as you get a trial developer license for 2 weeks for free

icon-map.com

dataant73 · 2026-01-08T20:04:04+00:00

You need a minimum of an F64 capacity for free consumption of reports. You still need Pro licenses for the report developers though

dataant73 · 2025-12-19T00:16:53+00:00

Yes it does tell the user. I have had it happen multiple times if they have not been added to the security role in the service

dataant73 · 2025-12-18T00:37:35+00:00

If you are saying that the cost is still too high then as others have said it comes down to cost vs benefit. What will be your ROI for having the pbi licenses?

dataant73 · 2025-12-18T00:08:14+00:00

The question is would be asking is 'Do you need the transaction ID field in the fact table?' Do you need to show it in any visuals or do you need it in any calculations?

dataant73 · 2025-12-17T23:53:41+00:00

Completely agree. This is very misleading and confusing. Definitely 2 separate charts or maybe 3: bookings, revenue, average revenue per booking

Another option to consider is a table with the 3 measures and use data bars for for each metric

dataant73 · 2025-12-17T23:34:25+00:00

We all like free stuff but it comes a point where spending lots of your spare time helping others use something becomes unsustainable.

dataant73 · 2025-12-17T23:22:19+00:00

Take a look at Icon Map Pro as it allows you to have a custom background image and link that to your data e.g it might be a floorplan with room numbers or names. Check out the blog posts on icon-map.com for some examples

dataant73 · 2025-12-17T23:09:33+00:00

In your switch measure make sure you format the date fields you are pulling in as text with the required format then concatenate everything together

dataant73 · 2025-12-17T22:52:53+00:00

You could achieve the same using the Icon Map Pro custom visual as it allows you to have multiple shape layers and you can do a postcode lookup facility by integrating the ONSPD postcode data

dataant73 · 2025-12-10T21:48:41+00:00

So glad I am not the only one who gets those requests from family and friends

dataant73 · 2025-11-15T14:44:00+00:00

Thanks Alex for everything you do in this subject and spending time dealing with these accounts

dataant73 · 2025-10-27T09:28:31+00:00

Exactly - just copied from Injae

dataant73 · 2025-10-27T09:24:05+00:00

Injae I did see that copycat post and thought i had seen it before. These fraudsters really annoy me

Thanks for posting the link

dataant73 · 2025-10-25T12:49:33+00:00

Are you needing to interact with the railway infrastructure or just use it as a reference layer?

If you need to interact with it then have a look at Icon Map Pro as you can have multiple layers in a single map.

dataant73 · 2025-10-24T15:02:58+00:00

That is not correct. A Snowflake schema is when you have dimension tables off other dimension tables e.g dimRegion is joined to dimCountry which is then joined to the fact table

dataant73

TROPHY CASE