ServiceDeskPlus API + Power BI Service
Hey all,
My organization has been working on leveraging the ServiceDesk Plus API as a data source for a Power BI semantic model, specifically for incident and service request reporting. When refreshing the semantic model in Power BI Desktop, it works a treat, but when I try to refresh in the Power BI Service after publishing, I get this error.
Data source error: DataSource.Error: Web.Contents failed to get contents from 'https://accounts.zoho.com/oauth/v2/token' (400): . Microsoft.Data.Mashup.ErrorCode = 10117. Microsoft.Data.Mashup.ValueError.DataSourceKind = Web. DataSourcePath = https://accounts.zoho.com/oauth/v2/token. Url = https://accounts.zoho.com/oauth/v2/token. . The exception was raised by the IDbCommand interface.
Cluster URI: WABI-US-GOV-IOWA-redirect.analysis.usgovcloudapi.net
Activity ID: 4a15f771-a1e7-4918-93d2-f6cd1a778743
Request ID: f4bc3e02-74c7-3317-5782-b8f69f048412
Time: 2026-06-10 21:18:18Z
Has anyone encountered this and found a solution? We have our model set up with a function refreshing the token using a client ID, secret, etc. and then that token is used to pull a list of all requests, and then we iterate through each request ID to pull metadata into one large fact table. Full disclosure: we do not have a developer on staff, so this is what our application analysts have been able to put together. If there's a better way to get a full list of requests with all detail, I'd love to hear about it.
Thanks!
Megan Bermudez
