Newbie needs help - 400 Error code

[Anonymous]

Good day all,

Forgive me if this is the wrong area to post in (completely new to this forum).

I am currently using the Sage API to GET data into MS Power BI.

This is the simple query I am running in Advanced Query.

Once I select done I get the following message

I have gone back to Sage and they have tested this in Postman and it works. 

Any ideas?

Any help would be greatly appreciated.

[V-pazhen-msft · Accepted solution]

@Anonymous 
That is not how to use API in Power Query, you can take a look at the tutorial.

Read API Data with Power BI using Power Query (mssqltips.com)

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[jennratten]

Here is a page that lists the requirements for the API call.  You would need to check your API Query function to make sure they are all handled properly - something is not being done correctly in the function.

https://developer.columbus.sage.com/docs#/uk/sage200/accounts/v1/nominal_period_value_views