Refresh not working for OAuth based Custom Connector in Power BI Service
Hi, we developed a custom connector for Power BI. It works fine perfectly in Power BI desktop. But, it doesn't work so in Power BI service. Both Manual and Scheduled reason fails for anonymous reason and atleast if the refresh log had a clearer note. We could have debugged the error.
Things we did :
1. Read an answer stating the need for "TestConnection" which is already set in our connector.
2. Cross checked data gateway which is also perfectly fine
3. Looked for solutions across the community but couldn't find any solution that could resolve our issue.
Hence, kindly anyone who has faced this issue and has overcome it successfully kindly throw us some light on crossing this issue.
I checked your steps but couldn't find any solution. I also explored the gateway logs and found the actual error. It says DM_GWPipeline_Client_OAuthTokenRefreshFailedError which basically is failure of oauth token refresh. I found the reason, but couldn't find any solution. Any help to this is largely appreciated. Thanks!
Same error for me. I checked the fiddler traffic and it appears that the api is returning the information I'm requesting through the custom connector, but Power BI Service isn't taking it in for whatever reason. Works perfectly find in Power BI Desktop. Anyone have any luck?
I'm stuck at exactly the same point. My custom connector for Google Spreadsheets works great in PowerBI Desktop, but in PowerBI Service both manual and scheduled refresh are causing problems. I can set up the gateway connection for my uploaded report in PowerBI Service, enter my Oauth2 credentials and schedule a refresh without problems. However, at the scheduled refresh time or when manually refreshing, Service is showing the following error: