Web API query suddenly stopped working with 400 error

[DazBox_za]

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?

[v-alq-msft]

Hi, @DazBox_za 

I wonder if you are using the lastest Power BI version. You can get the latest Power BI Desktop in two ways, each of which is described in the following sections:

• Install as an app from the Microsoft Store.
• Download directly, as an executable you download and install on your computer.

You may check if there are changes made in Power Query in Power BI.

Best Regards

Allan