API with dynamic access token can't refresh in Pow...

emilyh · ‎11-16-2021

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.

Quebas_2 · ‎08-23-2023

Did you find a solution?

aswathiram · ‎08-23-2023

If you have Power BI Premium license, we will be able to do the schedule refresh without issues.

aswathiram · ‎07-25-2023

Hi All.. I also have the same problem. Does any one know how to fix this?

v-rongtiep-msft · ‎11-18-2021

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 · ‎11-19-2021

Hi @v-rongtiep-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.