Forum Discussion
Issue with Data Refresh against ShipStation API
I am successfully connecting to The ShipStation API with a Web Data Source. I have goten confirmation that my query is exactly right and I am successfully pulling data initially. The Auth method is Anonymous/Organizational. However, in Power Bi Service, when I refresh data I get an error:
Data source error: {"error":{"code":"DMTS_OAuthFailedToGetResourceIdError","pbi.error":{"code":"DMTS_OAuthFailedToGetResourceIdError","parameters":{},"details":[],"exceptionCulprit":1}}}
Cluster URI: WABI-WEST-US3-A-PRIMARY-redirect.analysis.windows.net
Activity ID: 8c18f6dd-6426-4da2-a7dc-5a50f01f9e08
Request ID: 2ff8c121-4ce7-c05a-7b39-beef3517dce1
Time: 2026-07-09 19:51:14Z
I've been informed that this is a Power Bi Service defect. The service credentials are also set to anonymous/organizational so we should not be getting an Oath error.
Has anyone else experienced this and have any insight or recommendations?
TIA,
Scott
This is issue is resolved. I had to check "Skip Test" for the Service Datasource anonymouse setting for it to take.
6 Replies
Hi snoring
This can sometimes happen when your data source has got variable API coming back. And what that happens then is when you're actually running the query it is using a different call so the credentials will not get passed through successfully. An option to get this working is to store the credentials in the header if possible. Here is an example. https://blog.crossjoin.co.uk/2014/03/26/working-with-web-services-in-power-query/amp/
This is issue is resolved. I had to check "Skip Test" for the Service Datasource anonymouse setting for it to take.
Hi snoring,
Thank you for the update. I'm glad to hear you were able to resolve the issue.
I appreciate you sharing the solution. Enabling the "Skip Test" option for the Service Datasource anonymous setting will certainly be helpful for other community members who encounter the same issue.
Thanks again for following up and sharing the resolution.
