Forum Discussion
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?
1 Reply
- v-alq-msftCommunity Support
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