cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fonz11 Regular Visitor
Regular Visitor

Address works in PowerView and Power Maps but PowerBI won't plot correctly (HELP)

Anyone know the trick to get my all of my account's FULL ADDRESS (Street level...Address, City, State, ZIP) to plot correctly on the Map visualization? 

 

*I have already set the data type to Address

*I am using a calc column to concatenate the [Address] & ", " & [City]... to get the entire address to show

*I am including a MAX measure for the "values" field to indiate size on the map

*I included a text data type legend field as well

 

The most frusterating part is that the exact same addresses work just fine in Power View/Maps in excel 2013. 

I'm working with about 80,000 unique locations...so I'm excpecting to get the whole "too many values...representative sample" message...but i'm only getting back like ... 3 locations to show up on the Desktop app (Sept 15 update version). 

 

I literally copied the address column out of my PowerBI desktop table and into an excel table and this is what i got. 

Screen shots comparing PowerMap and PowerBI below. I'd expect for them to behave simmilarly (both use Bing, right?)

 

Untitled.png

 

I'd like to move off Sharepoint on premise and into PowerBI but wont be able to do so until the Maps work. 

 

Thanks for any tips you can offer,

 

Fonz

1 ACCEPTED SOLUTION

Accepted Solutions
Power BI Team meysun
Power BI Team

Re: Address works in PowerView and Power Maps but PowerBI won't plot correctly (HELP)

If it works in Power View, then it should work in Power BI as well. So it might be just data categorization issue.

Could you make sure the Data category is set to Address? If this doesn't solve the issue, could you send us the pbix file? You can either upload it as attachment or use the Send a Smile/Frown feature in Power BI Desktop to send the file to us.

 

 

7 REPLIES 7
Super User
Super User

Re: Address works in PowerView and Power Maps but PowerBI won't plot correctly (HELP)

There is a monumental difference between PowerMap and the mapping tool in Power View - maps or Power BI's map. A more apt comparison would be using the mapping feature in power view to Power BI.

In any case, have you tried to extrapolate what is "right" in your addresses that show up compared to what may be "wrong" in the others? Granted, 4 of 80K seems ridiculously small, but is there extra spacing, additional characters or some flaw in the string that Power Map is able to work around by PBI falls on it's face about?

Near SE WI? Join our PUG Milwaukee Brew City PUG
fonz11 Regular Visitor
Regular Visitor

Re: Address works in PowerView and Power Maps but PowerBI won't plot correctly (HELP)

Point well taken about the diff between PMap and PBI...i just thought the Geocoding part of it would be pretty close. 

 

I'll try starting with a more managable location set i can test and see what PBI likes better (formating) ...i just figured since 99.9% were failing i must have a more fundamental problem going on amd someone else might have already solved/ figured out a work around. I'll update if i make any progress. 

 

Thnx Eno. 

Power BI Team meysun
Power BI Team

Re: Address works in PowerView and Power Maps but PowerBI won't plot correctly (HELP)

If it works in Power View, then it should work in Power BI as well. So it might be just data categorization issue.

Could you make sure the Data category is set to Address? If this doesn't solve the issue, could you send us the pbix file? You can either upload it as attachment or use the Send a Smile/Frown feature in Power BI Desktop to send the file to us.

 

 

adam79 Visitor
Visitor

Re: Address works in PowerView and Power Maps but PowerBI won't plot correctly (HELP)

I'm having much the same experience, where complete street addresses are being plotted in 'default' locations in Power BI Desktop (e.g. centre point of the corresponding state capital), but seem to resolve correctly in Power View. The same address when pasted into Bing Maps resolves perfectly as well.

 

I've noticed this behaviour for quite a number of addresses, even when using a complete format of:

[Street No] [Street Name] [Road Type] [Suburb], [State], [Country]

 

Variants of this address formatting will either not plot at all, or plot in the same incorrect location. For problematic addresses I've not been able to find a variant that plots correctly in Power BI Desktop, although Power View and Bing Maps will both correctly plot several variations.

 

The field is categorised as 'Address'.

 

 

 

amien Member
Member

Re: Address works in PowerView and Power Maps but PowerBI won't plot correctly (HELP)

@meysuni can't get it to work. I'v send a Frown

Variable Occasional Visitor
Occasional Visitor

Re: Address works in PowerView and Power Maps but PowerBI won't plot correctly (HELP)

Hi there, i'm trying to get mapping working with addresses and nothing seems to be working for me. 

 

I've simplified the address search down to a single address in every format that i can think of:

 

I've basically put in a single address, catagorized it as an address and trying to get it to show up in the map. Nothing seems to work reliably.

 

I've used the following address for testing and can't reliably get a result.
101 Collins Street Melbourne Victoria Australia

 

Is there a definitive list of how the address needs to be formatted?

 

Alternatively has anyone found a way to convert an address to longatude latitude for 700,000 entries? at the moment only about 1000 are showing up.

Highlighted
SergeiStPete Frequent Visitor
Frequent Visitor

Re: Address works in PowerView and Power Maps but PowerBI won't plot correctly (HELP)

Such address works fine if only you categorize it in data model not as address, but as Place. Much better if you name your column with address as Place, when most probably Power BI will recognize it correctly even without categorization.

Place.JPG

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 93 members 1,774 guests
Please welcome our newest community members: