API with dynamic access token can't refresh in Power BI service

[emilyh]

Hello,

I have a report needs to get data from a REST API. To access the API, I need to first generate a access token and the token will be expired every 1 hour. I've searched many materials and was able to write a power query in Power BI desktop to generate the dynamic token and then refresh the dataset. However, after publishing the report to Power BI service, it won't allow me to refresh the dataset by schedule. Some of the posts say that we need to build a custom connector to make it work in Power BI service. 

Does anyone has idea is there some other way to make it work?

Thanks.

[v-polly-msft]

Hi @emilyh ,

Please refer to the following documents to see if it helps you.

http://blog.datainspirations.com/2018/02/17/dynamic-web-contents-and-power-bi-refresh-errors/

https://community.powerbi.com/t5/Service/Airtable-Power-Bi-Service-Dynamic-Source-Refresh-Error/m-p/...

If it does not solve your problem, please provide a screenshot on it.

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.

[emilyh]

Hi @v-polly-msft ,

I tried the solution you provided from the links, but did not work for my scenario. I need to access to a API with a dynamic access token which need to be refreshed every one hour. The access token is part of the header.

if I put the authorization part in a query, the authentication did not work.

it works using header, but it won't allow me to refresh in Power Bi service using this way.

[scuche]

Hi @v-polly-msft 

I have the same problem. Is there any solution for that?

Thanks