访问行相对于电源查询中的位置编号

Question

我有这个数据源 https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol=MSFT&interval=1min&apikey=demo

我想选择"时间序列（1分钟）"，然后首先从中记录 - 因为时间会发生变化，然后是"1.打开"。

我尝试使用此查询

= Json.Document(Web.Contents("https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol=MSFT&interval=1min&apikey=demo"), 1250)
= Source[#"Time Series (1min)"]{0}[#"1. open"]

但我得到：

Expression.Error: We cannot convert a value of type Record to type List.
Details:
    Value=Record
    Type=Type

这对我没有帮助 http://excel-inside.pro/blog/2015/11/05/absolute-and-relative-references-in-power-query/我认为问题可能在于我在引用第一行时变得空。

Answer 1

尝试：

let
Source = Json.Document(Web.Contents("https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol=MSFT&interval=1min&apikey=demo"), 1250),
#"Time Series (1min)" = Source[#"Time Series (1min)"],
#"Converted to Table" = Record.ToTable(#"Time Series (1min)"),
Value = #"Converted to Table"{0}[Value]
in
Value