Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

missing fields from Salesforce Objects source

Hi,

I'm trying to load the CaseMilestone object from Salesforce to Power Bi Desktop.

 

I manage to load most of the columns, but there are 7 missing:

 

BusinessHoursId
StoppedTimeInMins
StoppedTimeInHrs
StoppedTimeInDays
ActualElapsedTimeInMins
ActualElapsedTimeInHrs
ActualElapsedTimeInDays

I'm not removing any columns from the result.

 

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

When checking the same table via DataLoader I do get all the tables in my output.

 

Anyone has an idea what might be wrong here? And how to fix it :-).

 

Tnx & Regards,

Wim

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Thanks for the feedback.

 

I'm not sure these are custom fields. I believe they are standard (but will probably only exist in the DB once an option has been activated).

 

I have a workaround now, as apparently the fields have been copied to our Cases object as well. Not as clean, but it works for me.

 

Wim

View solution in original post

5 REPLIES 5
QueryWhiz
Post Patron
Post Patron

Hi, were you able to find a solution? As a workaround, maybe you can try to test your connection with a 3rd party connector., which is compatible with SF objects and works with custom fields too. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Salesforce connector in the data sources list:

 

SALESFORCE-1.png

After that, just grant access to your Salesforce account using your credentials, then on preview and destination page you will see a preview of your Salesforce fields:

 

SALESFORCE-2.png

 

There just select the fields you need. It is also compatible with custom fields and custom objects, so you'll be able to export them through windsor. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.

 

SELECT_DESTINATION_NEW.png

Anonymous
Not applicable

Hi @Anonymous,


If this is a case, please use api to get data form salesforce.

AFAIK, power bi connectors are packaged which fields can return back to power bi, by default it not support custom fields.

 

Regards,

Xiaoxin Sheng

Anonymous
Not applicable

Thanks for the feedback.

 

I'm not sure these are custom fields. I believe they are standard (but will probably only exist in the DB once an option has been activated).

 

I have a workaround now, as apparently the fields have been copied to our Cases object as well. Not as clean, but it works for me.

 

Wim

I am missing a work order that will not show in Power BI.  Did you ever get another solution other than copy to case object?

I am missing a work order that will not show in Power BI.  Did you ever get another solution other than copy to case object?

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.