Schedule refresh with power BI and Kobo forms

[Pranoti98]

Hello, 
I am facing error while refreshing on powerbi service. 
Data source error: {"error":{"code":"DMTS_OAuthFailedToGetResourceIdError","pbi.error":{"code":"DMTS_OAuthFailedToGetResourceIdError","details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Failed to get OAuth resource, please make sure the OAuth is supported"}}],"exceptionCulprit":1}}}
Cluster URI: WABI-UK-SOUTH-redirect.analysis.windows.net
Activity ID: c55eca70-cf71-408f-aba9-d3820fa4823f
Request ID: 8d3b7ee8-2b05-1c5e-c4cc-75bbf703d74a
Time: 2025-10-10 08:36:38Z

I have established connection between Kobo forms and Power BI which is successfully connected. I am able to refresh dashboard on Power BI, but when I published it on Power Service, and tried to refresh it there, it’s giving some authentication issue to semantic model for kobo.

what I have done so far:
I have created API URL for forms in Json format and added it to the power bi through web connector. ( used Anonymous identity level). Along with that I have added SharePoint URL ( which is working fine).

I tried different combinations for identity and privacy level on powerbi service but still showing same error.

I am not having any issue while refreshing it on power bi desktop.

[v-dineshya]

Hi @Pranoti98 ,

Thank you for reaching out to the Microsoft Community Forum.

Hi @grazitti_sapna  Thank you for your prompt response.

Hi @Pranoti98 , In addition to @grazitti_sapna  response , i have added some more points.

Power BI's Web connector when used with anonymous authentication or custom token-based APIs like KoboToolbox. While it works in Power BI Desktop, the Service requires a gateway or OAuth-compliant authentication for refreshes.

Troubleshoot refresh scenarios - Power BI | Microsoft Learn

Please try below things to fix the issue.

1. Install and configure a Personal Gateway on your machine or a VM. check the gateway is online and mapped to the dataset in Power BI Service. It  allows Power BI Service to refresh data using your local credentials and setup.

2. Try to build a Power Query custom connector that implements OAuth2 for KoboToolbox. It requires register an app in KoboToolbox if it supportes. Implement StartLogin, FinishLogin, and Refresh functions in M code. Use Power BI SDK to deploy the connector.

3. Use Power Automate to pull data from KoboToolbox and push it to a SharePoint list or Excel file. Connect Power BI to that SharePoint/Excel source. It avoids direct API calls from Power BI and leverages supported connectors.

4. Avoid Anonymous Authentication in Power BI Service unless the source is public.

5. If you are using Web.Contents, check you are not using Content option unless anonymous access is allowed.

6. Check if KoboToolbox offers OAuth-compatible endpoints or Microsoft Entra ID integration.

Please refer below links.

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

Solved: Web.contents unbale to authenticate with anonymous... - Microsoft Fabric Community

Solved: DMTS_OAuthFailedToGetResourceIdError - Microsoft Fabric Community

Solved: Re: DMTS_OAuthFailedToGetResourceIdError (English ... - Microsoft Fabric Community

Solved: Web API Anonymous access - Microsoft Fabric Community

Solved: PowerBI refresh error - Microsoft Fabric Community

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh

[v-dineshya · Accepted solution]

Hi @Pranoti98 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

[Pranoti98]

Hello,

Yes, My issue has been resolved. I have used the first solution i got through comment through this portal and its sorted. 
Thank you so much

[grazitti_sapna]

Hi @Pranoti98 

Please try these troubleshooting steps:

• Use the Web connector in Power BI Desktop with the Kobo API URL in Advanced mode.
• Instead of Anonymous authentication, configure the Web connector to use the HTTP request header for API token authentication. Set the Authorization header as:
  Authorization: Token [Your Kobo API Token]
• Ensure the API token is valid and has the required permissions in Kobo.
• Refresh and verify the data loads successfully in Power BI Desktop.
• Publish the report/dataset to Power BI Service.
• In Power BI Service, go to the dataset settings for the refreshed dataset.
• Under Data source credentials, edit the Kobo API data source:
  • Choose OAuth2 or Web API authentication as applicable.
  • Input the API token or complete OAuth sign-in to authenticate.
  • Set privacy level to Organizational or as appropriate.
• Clear any cached or old credentials related to this data source in Power BI Service and re-enter fresh credentials.
• Try refreshing the dataset again in Power BI Service.
• If error persists, confirm the Kobo API URL is stable, non-redirecting, and reachable from the Power BI Service environment.
• Check for network restrictions or gateway issues if using one.

This method ensures Power BI Service has the required authentication tokens for scheduled refreshes and avoids the "DMTS_OAuthFailedToGetResourceIdError" caused by anonymous authentication on OAuth-protected APIs.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.

💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.

🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.

🔗 Curious to explore more? [Discover here].

Let’s keep building smarter solutions together!