function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Dale NewnhamDale Newnham 

Cannot access work order object via API using Power Query

I cannot see the work order object via the Microsoft power query Salesforce object connector. I can succesfully view and query many other objects but the work object does not appear in the power query navigator view (see screenshot). This article states that the work order object is supported by API version 36.0 and later so perhaps power query uses an earlier version?
.User-added image
SandhyaSandhya (Salesforce Developers) 
Hi,

I think it is the same version issue as you said by referring below discussion.

https://developer.salesforce.com/forums/?id=906F0000000D8WyIAK
 
Thanks and Regards
Sandhya
Chuck TomlinsonChuck Tomlinson

Yes, Sandhya, it is a similar version issue.
However, Workbench has since been updated (as it does pretty soon after each new API release) and I believe the Excel connector to SF Objects uses an API version < 30 or something.. Obviously less than 36.0

I have been looking for perhaps a registry key to set the endpoint URL that PowerQuery uses to hit SF but haven't found anything pertinent yet..