Forum Discussion

Boleslaw's avatar
Boleslaw
New Member
3 years ago
Solved

Power Query to access Open Route maps

Hello, I am looking for help with my POST request in Power Query. I am trying to use matrix service but with no luck so far. I am receiving the following error: DataSource.Error: Web.Contents faile...
Need Help
  • ams1's avatar
    ams1
    3 years ago

    Hi Boleslaw 

     

    Yeah, in PowerQuery lists use "{" instead of "[":

     

    ...
postData = Json.FromValue([locations={{9.70093,48.477473},{9.207916,49.153868},{37.573242,55.801281},{115.663757,38.106467}}])
...

     

    Please mark this as answer if it helped.

ams1's avatar
ams1
Responsive Resident
3 years ago

Hi Boleslaw 

 

Yeah, in PowerQuery lists use "{" instead of "[":

 

...
postData = Json.FromValue([locations={{9.70093,48.477473},{9.207916,49.153868},{37.573242,55.801281},{115.663757,38.106467}}])
...

 

Please mark this as answer if it helped.