laurprague
New Member
- Joined
- Mar 24, 2014
- Messages
- 4
Hi,
Please find an example of the table below which I am trying to put in a map in Power view.
Power view opens but do not recognize / locate the addresses in the Czech Republic. Funnily enough, using the same table, Power Map is able to locate the address automatically. Power view works as I am able to use a table of US addresses with no problem.
Bing is able to locate the addresses.
So, what could be the problem ? (I tried to play with the columns and the addresses, city, ... but with no success).
I am sure the answer can be easily found but I can't get it ....
TABLE:
[TABLE="width: 320"]
<tbody>[TR]
[TD="class: xl63"]Locality[/TD]
[TD="class: xl64, width: 80"]Neighbourhood[/TD]
[TD="class: xl64, width: 80"]Address[/TD]
[TD="class: xl64, width: 80"]data[/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Bohnice[/TD]
[TD="class: xl66"]Bukolská[/TD]
[TD="class: xl67"][/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Bohnice[/TD]
[TD="class: xl66"]Hlivická[/TD]
[TD="class: xl67, align: right"]182[/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Bohnice[/TD]
[TD="class: xl66"]Kostřínská[/TD]
[TD="class: xl67"][/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Bohnice[/TD]
[TD="class: xl66"]Lodžská[/TD]
[TD="class: xl67"][/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Bohnice[/TD]
[TD="class: xl66"]Radomská[/TD]
[TD="class: xl67"][/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Bohnice[/TD]
[TD="class: xl66"]Štětínská[/TD]
[TD="class: xl67, align: right"]132[/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Bohnice[/TD]
[TD="class: xl66"]Toruňská[/TD]
[TD="class: xl67, align: right"]188[/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Bohnice[/TD]
[TD="class: xl66"]Vratislavská[/TD]
[TD="class: xl67"][/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Bohnice[/TD]
[TD="class: xl66"]Zelenohorská[/TD]
[TD="class: xl67, align: right"]163[/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Braník[/TD]
[TD="class: xl66"]Branická[/TD]
[TD="class: xl67, align: right"]250[/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Braník[/TD]
[TD="class: xl66"]Jílovská[/TD]
[TD="class: xl67"][/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Braník[/TD]
[TD="class: xl66"]Ke Krči[/TD]
[TD="class: xl67, align: right"]241[/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Braník[/TD]
[TD="class: xl66"]Nad lesním divadlem[/TD]
[TD="class: xl67, align: right"]226[/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Braník[/TD]
[TD="class: xl66"]Nad vinohradem[/TD]
[TD="class: xl67, align: right"]258[/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Braník[/TD]
[TD="class: xl66"]Ohnivcova[/TD]
[TD="class: xl67, align: right"]143[/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Braník[/TD]
[TD="class: xl66"]Vavřenova[/TD]
[TD="class: xl67, align: right"]234[/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Braník[/TD]
[TD="class: xl66"]Vlnitá[/TD]
[TD="class: xl67, align: right"]258[/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Braník[/TD]
[TD="class: xl66"]Za Mlýnem[/TD]
[TD="class: xl67, align: right"]210
[/TD]
[/TR]
</tbody>[/TABLE]
Please find an example of the table below which I am trying to put in a map in Power view.
Power view opens but do not recognize / locate the addresses in the Czech Republic. Funnily enough, using the same table, Power Map is able to locate the address automatically. Power view works as I am able to use a table of US addresses with no problem.
Bing is able to locate the addresses.
So, what could be the problem ? (I tried to play with the columns and the addresses, city, ... but with no success).
I am sure the answer can be easily found but I can't get it ....
TABLE:
[TABLE="width: 320"]
<tbody>[TR]
[TD="class: xl63"]Locality[/TD]
[TD="class: xl64, width: 80"]Neighbourhood[/TD]
[TD="class: xl64, width: 80"]Address[/TD]
[TD="class: xl64, width: 80"]data[/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Bohnice[/TD]
[TD="class: xl66"]Bukolská[/TD]
[TD="class: xl67"][/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Bohnice[/TD]
[TD="class: xl66"]Hlivická[/TD]
[TD="class: xl67, align: right"]182[/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Bohnice[/TD]
[TD="class: xl66"]Kostřínská[/TD]
[TD="class: xl67"][/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Bohnice[/TD]
[TD="class: xl66"]Lodžská[/TD]
[TD="class: xl67"][/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Bohnice[/TD]
[TD="class: xl66"]Radomská[/TD]
[TD="class: xl67"][/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Bohnice[/TD]
[TD="class: xl66"]Štětínská[/TD]
[TD="class: xl67, align: right"]132[/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Bohnice[/TD]
[TD="class: xl66"]Toruňská[/TD]
[TD="class: xl67, align: right"]188[/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Bohnice[/TD]
[TD="class: xl66"]Vratislavská[/TD]
[TD="class: xl67"][/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Bohnice[/TD]
[TD="class: xl66"]Zelenohorská[/TD]
[TD="class: xl67, align: right"]163[/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Braník[/TD]
[TD="class: xl66"]Branická[/TD]
[TD="class: xl67, align: right"]250[/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Braník[/TD]
[TD="class: xl66"]Jílovská[/TD]
[TD="class: xl67"][/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Braník[/TD]
[TD="class: xl66"]Ke Krči[/TD]
[TD="class: xl67, align: right"]241[/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Braník[/TD]
[TD="class: xl66"]Nad lesním divadlem[/TD]
[TD="class: xl67, align: right"]226[/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Braník[/TD]
[TD="class: xl66"]Nad vinohradem[/TD]
[TD="class: xl67, align: right"]258[/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Braník[/TD]
[TD="class: xl66"]Ohnivcova[/TD]
[TD="class: xl67, align: right"]143[/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Braník[/TD]
[TD="class: xl66"]Vavřenova[/TD]
[TD="class: xl67, align: right"]234[/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Braník[/TD]
[TD="class: xl66"]Vlnitá[/TD]
[TD="class: xl67, align: right"]258[/TD]
[/TR]
[TR]
[TD="class: xl65"]Praha[/TD]
[TD="class: xl66"]Braník[/TD]
[TD="class: xl66"]Za Mlýnem[/TD]
[TD="class: xl67, align: right"]210
[/TD]
[/TR]
</tbody>[/TABLE]