Solved: power query

Anonymous · ‎05-26-2020

there is an error to connect data file from yelp with Jason to excel to convert in excel format.

How can o change syntax of Jason input yo resolve issue and convert data into excel? please reply with syntax and snapshot of solution

v-eachen-msft · ‎05-27-2020

Hi @Anonymous ,

Do you mean to use power query to import the json files from yelp.com?

So you could use the following codes:

Json.Document(Web.Contents("Your URL"))

Here are some documents and videos for your reference.

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

v-eachen-msft · ‎05-27-2020

Hi @Anonymous ,

Do you mean to use power query to import the json files from yelp.com?

So you could use the following codes:

Json.Document(Web.Contents("Your URL"))

Here are some documents and videos for your reference.

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

power query