Forum Discussion

DazBox_za's avatar
DazBox_za
Frequent Visitor
5 years ago

Web API query suddenly stopped working with 400 error

I have a PBIX file that updates a dashboard with information from multiple sources. I've been refreshing this dataset daily without any issues for a few months without any issues.

This recently (seemingly out of nowhere - no changes have been made) stopped working due to an issue with one of the Rest API queries. The strange thing is that this query still works perfectly if i make the call through Excel's Power Query, but not in PBI Desktop.

Here's the query:

Let

Source = Json.Document(

Web.Contents(

"https://app.wavo.co/api/v1/campaigns",

[Headers=[

#"Content-Type"="application/json",
Accept="application/json",
Authorization="Bearer [API KEY]"

]])),

data = Source[data],
#"Converted to Table" = Table.FromList(data, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
in

#"Converted to Table"

This is the error I get (Note: The query has not been altered since last it worked):

...Any ideas?