Getting Refresh Token Expired Error in Power BI Service

[agarwala]

Hello folks,

I am trying to execute a Power BI report which keeps on throwing the error:

When I go to dataset settings page I can see the warning icon below (Cherwell is one of the Rest API name that this report is using as a data source):

When I click on 'Edit Credentials'  and 'Sign in'

Error goes away and the report works absolutely fine.

So the problem is with the Rest API I have to verify the credentials again and again in sometime  otherwise the report keeps on throwing error above.

Could someone pls advise how to resolve this issue permanently?

Thanks

[agarwala]

Thanks will try that.

[lbendlin]

You can't. Token expiration is part of the security setup.

[agarwala]

Thanks for replying so what should I do in this scenario to make sure refresh token never expires?
Is there any such setting in power bi specifically that I can try pls.

[lbendlin]

There is no setting. Tokens expire.

[agarwala]

Thanks for replying @lbendlin .

So are there any used case where the setting has been configured to auto renew the token once it expires?

I could see an M code example below but I have no idea how should I go ahead with this 😞

[lbendlin · Accepted solution]

You create a custom connector for that.

Handling authentication for Power Query connectors - Power Query | Microsoft Learn