Get data from API with token

[trogne]

I'd like to use a Springshare LibCal API as a data source.

And I want auto-refresh possible for the Power BI service.

I was able to use a Python script in Power BI desktop, and I can refresh from there.

But of course, auto-refresh won't work in the Power BI service since it does not have access to my local Python script.

So what can I do with the API, so that the auto-refresh works ?

The API first needs a valid token, the it uses that token for the API calls, with Authorization: Bearer {TOKEN}.

Is there any way I can set up API authentications and calls from the Power BI service ?

[trogne]

I created an API on Vercel that does the authentication and outputs the json.

I use my API link as the data source for Power BI.

Is that an overkill solution ?  Would a custom connector (and a gateway) be an easier and more effective solution ?

[lbendlin]

I think the final result will be the same. If your solution works then use it.

[lbendlin · Accepted solution]

You need to create a custom connector (and a gateway) to be able to refresh that source in the service.