Salesforce Objects Agent Work and User Presences not available for query

There are 2 Salesforce Objects I am unable to find in Power BI, Agent Work and User Presences. Both the objects are Salesforce Omni Solutions. I have already checked Objects/Tabs Rename Label setting and we are using the same name. 

priyankjain4u,

What connector do you use to connect to the data source in Power BI, Salesforce object or Salesforce report?

Regards,
Lydia

Hi priyankjain4u

I think the problem is related to the API version, Power BI connector is using 29 and, for example, AgentWork is 32 or later. 

A workaround can work, extract with dataloader, sync to another db, copy records to custom object, etc, but we can not connect to the object with current connector.

Pablo

Hi,

I managed to find a work around for this issue, that doesn't limit the query to 2000 rows.

In PBI go to Get data -> Salesforce Objects

Pick any object and choose Edit when you load it which will take you straight to the Query Editor.

Press Advanced Editor under the Home tab.

Replace the text with:

For Agent Work

let
Source = Salesforce.Data("https://login.salesforce.com/", [CreateNavigationProperties=true, ApiVersion=43]),
AgentWork = Source{[Name="AgentWork"]}[Data]
in
AgentWork 

For User Presence

let
Source = Salesforce.Data("https://login.salesforce.com/", [CreateNavigationProperties=true, ApiVersion=43]),
UserServicePresence = Source{[Name="UserServicePresence"]}[Data]
in
UserServicePresence

And press Ok.

This should load the objects in to PBI. You will only have the SFDC ID's for Service Channels and so on, but you can replace the values with whatever you choose.

Had struggles with this since May and this finally worked for me, hope it does for you to!