Convert Israeli cordianets to use them in dashboard

[Anonymous]

Hi,

i got cordinates like those:

Y  X

644796.768174265

how can i convert them to use it in power bi map?
thanks.

[Anonymous]

Hi,

i got cordinates like those:

Y                                  X

644796.768174265    199575.078316823

644717.913914994    199367.247692828
646360.979701126    201283.760900855

How can i convert them to use it in power bi map?
I cant use python, i can use Power Query, SQL or ADF.
thanks.

[AmiraBedh]

The coordinates you provided seem to be in the Israeli Transverse Mercator (ITM) coordinate system, and you likely want to convert these to a global coordinate system such as WGS84 (which uses latitude and longitude) to be able to use them in a map visual.

Here is a repo that you can use it : https://github.com/zvizvi/ITM-to-WGS84

Another link to help you : https://stackoverflow.com/questions/14329691/convert-latitude-longitude-point-to-a-pixels-x-y-on-mer...

[Anonymous]

thank for your answer.

as I said, i cant use any programming language' only SQL or Azure Data Factory.

can I do it with this tools?

[AmiraBedh]

While it is not the adequate platform to ask about SQL/Azure, here is a link to guide you : https://gis.stackexchange.com/questions/214833/convert-nztm-to-latitude-longitude-in-sql