Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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 StoppedT...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

metrica's avatar
metrica
Post Prodigy
24 days ago

Hi Wim,

 

Since Data Loader returns these CaseMilestone fields, I would first confirm that both tools use the same Salesforce user and API version. In the current Salesforce Objects connector, you can explicitly set a supported ApiVersion in the Salesforce.Data call.

 

Power BI Connector for Salesforce may also be worth testing. It lets you select and preview the Salesforce objects and fields available to the application user before importing them into Power BI. This can help determine whether the issue is specific to the native connector.

 

AppExchange and 30-day free trial:
https://appexchange.salesforce.com/appxListingDetail?listingId=31526f0e-abd8-4cb5-bd1a-3bd56b5c0577

 

Documentation:
https://metricasoftware.com/docs/salesforce/

 

Support and demo:
https://metricasoftware.com/docs/salesforce/contact-support/

 

Cheers,
Metrica Team