Power Query : Google map KPI : "We cannot convert the value 0 to type Table"

[nanutum]

i used Googlemap Kpi :  Reverse Geocoding

My Code 

let
    Source = Excel.CurrentWorkbook(){[Name="GPS"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Customer_Code", type text}, {"Latitude", type number}, {"Longitude", type number}}),
    #"Rounded Off" = Table.TransformColumns(#"Changed Type",{{"Latitude", each Number.Round(_, 5), type number}, {"Longitude", each Number.Round(_, 5), type number}}),
    #"Added Custom" = Table.AddColumn(#"Rounded Off", "Custom", each try #"Maping"(Number.ToText([Latitude]),Number.ToText([Longitude])) otherwise 0),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"postal_code", "administrative_area_level_1"}, {"postal_code", "administrative_area_level_1"})
in
    #"Expanded Custom"

Result 

Result Gps

 in Power Query is not show Error 

when "close and load" show this error 

Please Help me

[Jimmy801]

Hello @nanutum 

what is returning this query?

let
    Source = Excel.CurrentWorkbook(){[Name="GPS"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Customer_Code", type text}, {"Latitude", type number}, {"Longitude", type number}}),
    #"Rounded Off" = Table.TransformColumns(#"Changed Type",{{"Latitude", each Number.Round(_, 5), type number}, {"Longitude", each Number.Round(_, 5), type number}}),
    #"Added Custom" = Table.AddColumn(#"Rounded Off", "Custom", each try #"Maping"(Number.ToText([Latitude]),Number.ToText([Longitude])) otherwise 0),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"postal_code", "administrative_area_level_1"}, {"postal_code", "administrative_area_level_1"})
in
    Table.SelectRowsWithErrors(#"Expanded Custom")

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[nanutum]

@Jimmy801 

This code return Address from Lat and Long

[Jimmy801]

Hello @nanutum 

i modified this query in order to return your table with all rows that contain an error. So in some way, this result given by my query should give you the row(s) that causing the error when importing in power BI

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy