How to schedule refresh API source with Authorization header

[wes-shen]

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

[v-rongtiep-msft]

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: 

Embed Token 

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.

[Greg_Deckler]

@wes-shen Did you click the Edit credentials link?

[wes-shen]

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.