Forum Discussion
Power Query : Google map KPI : "We cannot convert the value 0 to type Table"
i used Googlemap Kpi : Reverse Geocoding My Code let
Source = Excel.CurrentWorkbook(){[Name="GPS"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Custom...
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
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