Warning message on map visual - one or more lat/lng values are not valid

[mtomova]

Hi,

I have a map visual on which I am plotting properties using latitude and longitude values.

The map works fine, there are no errors, however, there is this ' i ' icon showing in the top right corner of the map.

When I click on it I see this message:

There are no lat/lng values in my dataset which are outside of the specified ranges.

I have also made sure that the columns are in decimal format and are categorized as 'Latitude' and 'Longitude'.

However, this warning message still apears.

I wonder what is causing this and could it potentially break the report visual.

Thanks,

Maria

[v-hashadapu · Accepted solution]

Hi @mtomova , Thank you for reaching out to the Microsoft Community Forum.

The warning on your Power BI map visual typically shows up when there’s at least one row in your data where the latitude or longitude is missing, null or non-numeric (like N/A), even if all visible values look fine and are within the valid range. This won’t break your report, the map still works and plots valid points, but the warning appears because Power BI is skipping invalid rows in the background.

Go to Power Query and use M code to filter for problematic rows. Example:

= Table.SelectRows(Source, each

    try not (

        [Latitude] >= -90 and [Latitude] <= 90 and

        [Longitude] >= -180 and [Longitude] <= 180

    ) otherwise true)

Also check for nulls directly in both columns and make sure their data types are set to Decimal Number. Once you clean or remove these bad rows, the warning will go away. If your data refreshes often, consider keeping the filter step in place to avoid future issues.

If this helped solve the issue, please consider marking it “Accept as Solution” and giving a ‘Kudos’ so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.

[mtomova]

Hi,

you are right, there were few rows in my dataset where the lat and lng columns were blank/null.

Thank you for the advice, once I have populated the missing values the ' i ' icon disappeared.

Thanks,

Maria