Query stopped working on Excel, still work fine on PowerBI

[Thomas_-BA]

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://dataservices.imf.org/REST/SDMX_JSON.svc/CompactData/CPI/M..PCPI_IX?startperiod=2010"))

I now get this error when I try to refresh the data: DataSource.Error: "The downloaded data is HTML, which is not the expected type. Maybe the URL is wrong or maybe you didn't provide the right credentials to the server."

This had worked for a long time before today and still works on the PowerBi query editor so it's very odd. I never used any credentials for this query.

Any help that can be given will be greatly appreciated,

Have a great day

[#2]

@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