Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Auto refresh fails the credentials are invalid

Hi all, We have a Power BI Dashboard that reads Cherwell data as a data source. We have it scheduled for auto refresh during the night. The auto fresh frequently fails with ' (500): Internal Server...
authentication
Cherwell
dataset refresh
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Icey,

This issue has not been resolved and I don't know how I got an email that a reply has been accepted as a solution. I now understand why the Access token expires in 24 hours. That being the case, how do I go about using Refresh token instead which has a longer life span? Also the error message in the diagram shows '400 Bad Request', the message we are getting is ' (500): Internal Server Error'.

 

Thanks so much!

 

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

 

I know little about Cherwell. Just give some reference:

 

1. Please check if this blog could help you:

Get Data from Twitter API with Power Query - Chris Koester;

 

In this blog, the author uses the Twitter POST oauth2/token method to obtain a bearer token.

 

2. Or, may be you need to build a custom connector, if you want to connect from Power BI to a REST API that uses OAuth2 authentication. You can find documentation on how to implement an OAuth2 flow in a custom connector here.

 

Reference: 

Chris Webb's BI Blog: Connecting To REST APIs With OAuth2 Authentication In Power Query/Power BI Chris Webb's BI Blog (crossjoin.co.uk);

Solved: Refresh token api call - Microsoft Power BI Community

 

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.