Forum Discussion
How to schedule refresh API source with Authorization header
Hi there,
On Power BI desktop, I successfully connected to a API web source with "Authorization" as header and a bearer token.
In the data source settings, the type is set to Anonymous
I've published the report successfully onto Power BI Service.
However, I encountered a (400) Bad Request error when I tried to authenticate the data source, which I believe I need to do in order to schedule a data source refresh.
Any ideas how I can resolve this?
Thanks
Wes
3 Replies
wes-shen Did you click the Edit credentials link?
Hi Greg_Deckler , yes i did. And the last screenshot in my post was what happened after i clicked on the Edit Credentials and tried to authenticate.
Hi wes-shen ,
400 error can be like malformed request syntax, invalid request parameters, or deceptive request routing etc.
Does you use Power BI Rest APIs to set schedule refresh? If so, you may have set your parameters incorrectly. Refer to the example code posted here and these documentation:
Datasets - Refresh Dataset In Group
How to refresh Power BI dataset with REST API using SSIS
I have also found a similar post, please refer to it to see if it helps you.
Solved: (400) Bad Request using Web.Contents to connect to... - Microsoft Power BI Community
- following the instructions in this blog to connect to your data source.
- If you still get error, you can use Fiddler to track the process following the guide in this video.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
