Wednesday, February 17, 2016

Power BI Desktop issue - More location data is required to create a filled map.

I just ran into this issue while trying to create a 'filled map' visual in Power BI Desktop. The exact error message is:

More location data is required to create a filled map. To create a filled map, the location data should include Bing Map-supported geographic data, such as country/region, state/province, or postal code.

I tried using country, state etc. as suggested in the error message but got the same error. I also tried switching the visual to a regular map - though it didn't throw any errors, it didn't work (won't show any data points etc.) As shown in the screenshot below, I have a column called business_address_01_city in my data model and Power BI desktop doesn't seem to think that this column stores geographic data (even after adding state, country, etc.). 
More location data is required to create a filled map.

So I did some troubleshooting and figured out that there are two ways to address this issue:

1. Have the column names as City, State, ZipCode, etc. This will force Power BI Desktop to think that the columns store geographic data. I acknowledge that this could be an issue if you have more than one City or State fields in the model and/or if you have certain naming conventions you'd like to stick with.

2. Assign the correct Data Category for the column in the Modeling tab as shown in the screenshot below. For example, if there is a column called business_address_01_country in the data model, select the column and change the Data Category to Country and Power BI Desktop will understand that this column has geographic data.



I hope this is helpful. If anyone has another solution they used to resolve this issue, please let me know by posting a note in the comments.

13 comments:

  1. Thanks for your detailed explanation. By going through your post.
    Microsoft Power BI Online Training

    ReplyDelete
  2. Hey, thanks for this post ..! great concepts. I want to Know more about power bi consultants. so please share more post with me.

    ReplyDelete
  3. I think Power BI is one of the best tools for creating reports for end users and hence its aspects should actually be utilised properly in order to break down some very complex IT problems.

    Powerbi Read Rest

    ReplyDelete
  4. Thanks for sharing this valuable information and we collected some information from this blog.

    Machine learning in-house Corporate training in Nigeria

    ReplyDelete

  5. I like your blog, I read this blog please update more content on hacking,Nice post Power BI Online Training

    ReplyDelete
  6. Too Good article,Thank you for sharing it.
    Keep Updating...

    Power BI Online Training India

    ReplyDelete

  7. We Providing Mulesoft Training Courses In Hyderabad Ameerpet.Mulesoft
    Training In Hyderabad. Mule ESB Training In Ameerpet Hyderabad.100% Job Oriented
    Certifications Assistance.Placement Guaranteed Mulesoft Training Courses in Hyderabad.

    ReplyDelete