Forum Discussion

Thomas_-BA's avatar
Thomas_-BA
Copper Contributor
Sep 17, 2021

Query stopped working on Excel, still work fine on PowerBI

Hello everyone,   One of the queries I use in the Excel query editor stopped working today and I can't find the reason.   The public query is as follows : Json.Document(Web.Contents("http://datas...
BI & Data Analysis
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Sep 17, 2021

Thomas_-BA 

I can't reproduce

let
    Source = Json.Document(Web.Contents("http://dataservices.imf.org/REST/SDMX_JSON.svc/CompactData/CPI/M..PCPI_IX?startperiod=2010")),
    #"Converted to Table" = Record.ToTable(Source),
    #"Expanded Value" = Table.ExpandRecordColumn(#"Converted to Table", "Value", {"@xmlns:xsi", "@xmlns:xsd", "@xsi:schemaLocation", "@xmlns", "Header", "DataSet"}, {"@xmlns:xsi", "@xmlns:xsd", "@xsi:schemaLocation", "@xmlns", "Header", "DataSet"}),
    #"Expanded DataSet" = Table.ExpandRecordColumn(#"Expanded Value", "DataSet", {"@xmlns", "Series"}, {"@xmlns.1", "Series"}),
    #"Removed Other Columns" = Table.SelectColumns(#"Expanded DataSet",{"Series"}),
    #"Expanded Series" = Table.ExpandListColumn(#"Removed Other Columns", "Series"),
    #"Expanded Series1" = Table.ExpandRecordColumn(#"Expanded Series", "Series", {"@FREQ", "@REF_AREA", "@INDICATOR", "@UNIT_MULT", "@COMMON_REFERENCE_PERIOD", "@TIME_FORMAT", "Obs"}, {"@FREQ", "@REF_AREA", "@INDICATOR", "@UNIT_MULT", "@COMMON_REFERENCE_PERIOD", "@TIME_FORMAT", "Obs"})
in
    #"Expanded Series1"

I'm on

 

Resources