Using PowerQuery to import JSON?

[d0rian]

I've never used 365's PowerQuery before, but I'm told that it can handle exactly these kinds of requests. Here's a static Yahoo URL with all the stock option data for symbol AAPL: https://query1.finance.yahoo.com/v7/finance/options/AAPL

But not sure where to go from here; following online how-to's led me to Data > Get Data > Other Sources > From Web, and I pasted the URL > then Load Into Table...but I get the following screen, and not sure where to go from here. All the data is clearly at the URL, but Excel seems to only be recognizing a single row? (I'm sure I'm missing something obvious, this is my first time using this feature.)

 

[sandy666]

expand double arrows
then ...
expand double arrows
then...
repeat until you see all arrows are exapnded in all columns
then transform data as you wish, remove columns, filter... etc.

will be 107 columns

 

[d0rian]

ah....not sure what you mean by "expand double arrows"?

 

[sandy666]

on your picture you've two drop down
first simple with down arrow
second with left and right arrow - just expand this (just simply click on it)