Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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:
You may check if there are changes made in Power Query in Power BI.
Best Regards
Allan