Api HTTPs and gateway

[clavigne]

Hello,

I have been having a problem for some time that I cannot resolve.

In order to design my report, I use three sources:
- a SQL server connection via the gateway
- a connection to an Excel file stored on a one drive
- A connection to a web API in HTTPs.

The latter is secured by a token which changes every day.

What I did: A first request will look for the token
Then other sources use it.

When I am in the Power BI desdktop everything is OK but as soon as I try to publish it does not work because I would like to use the gateway for the SQL source but not for the other two.

could you help me ?

[lbendlin]

What error message do you get on the service?