正在获取错误消息：使用Power BI Power Query导致此连接发生冲突
let Fonte = Json.Document(Web.Contents("https://dadosabertos.aneel.gov.br/api/3/action/datastore_search_sql?sql=SELECT " & """DscClasseConsumo"", ""CodClasseConsumo""," & """sum(MdaPotenciaInstaladaKW)""" & " from ""b1bd71e7-d0ad-4214-9053-cbd58e9564a7""" & "group by ""DscClasseConsumo"" ,""CodClasseConsumo""")),
#"Convertido para Tabela" = Table.FromRecords({Fonte}),
#"result Expandido" = Table.ExpandRecordColumn(#"Convertido para Tabela", "result", {"sql", "records", "fields"}, {"result.sql", "result.records", "result.fields"})
in
#"result Expandido"字符串
1条答案
按热度按时间d5vmydt91#
您的代码计算为
字符串
如果您手动执行此查询，您将使用什么，以及它的比较结果如何