Forum Discussion
Helper ISalesForce Connector and PickList
Hi
Is it possible to help me with the SalesForce Object Connector
I would like get ID and Values not only ID
is it possible ?
Hi ShaunLeMouton ,
yeah, by default the Salesforce connector pulls the raw ID for picklist fields. If you want the label (text value) as well, here’s what you can try:
1. Use the ...__c and ...__c.label fields
In some Salesforce APIs (like REST or SOQL), you can access both the ID and label like this:SELECT Status__c, Status__c.label FROM MyObject
But this doesn’t always work in Power BI or Fabric directly.
2. Workaround: Join with the Picklist Metadata
You can pull the picklist values from the Salesforce metadata API and join them manually in Power BI. It’s a bit of a pain, but works.3. Use a custom SOQL query (if supported)
If your connector allows custom SOQL, you can write a query that includes both ID and label fields (some standard fields support this).Let me know which connector you’re using (Power BI, Fabric Dataflow, etc.) – I can give a more specific example.
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
4 Replies
Hi ShaunLeMouton,
Thanks for reaching out to the Microsoft Fabric Forum Community.
And asko thanks to burakkaragoz for Prompt and helpful solution.Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.
If the response addressed your query, kindly mark it as Accepted Solution and click Yes if you found it helpful this will benefit others in the community as well.
Best regards,
Prasanna Kumar
ShaunLeMoutonHi
I share my solution
In Fabric i use a pipleline and SalesForce Object connector
I use the SOSQL Option with this sql query
SELECT Label,Value FROM PicklistValueInfo WHERE EntityParticle.EntityDefinition.QualifiedApiName = 'LearningProgram' AND EntityParticle.QualifiedApiName = 'ge_Program__c' and isActive = true LIMIT 1000
- burakkaragoz
Super User
Thank you for sharing your solution! This is quite helpful.
Using the SOQL Option with a custom query in Fabric is indeed an excellent workaround for the picklist identification issue. Your approach of directly querying the PicklistValueInfo object is clever and bypasses the schema discovery limitations.
For anyone else facing similar issues with picklist fields in the Salesforce connector, this query pattern:
SELECT Label,Value FROM PicklistValueInfo WHERE EntityParticle.EntityDefinition.QualifiedApiName = 'LearningProgram' AND EntityParticle.QualifiedApiName = 'ge_Program__c' and IsActive = true LIMIT 1000Provides a direct way to access picklist values while avoiding the connector's schema discovery bug.
Have you found this method to be reliable across different types of picklist fields, including multi-select picklists?
- burakkaragoz
Hi ShaunLeMouton ,
yeah, by default the Salesforce connector pulls the raw ID for picklist fields. If you want the label (text value) as well, here’s what you can try:
1. Use the ...__c and ...__c.label fields
In some Salesforce APIs (like REST or SOQL), you can access both the ID and label like this:SELECT Status__c, Status__c.label FROM MyObject
But this doesn’t always work in Power BI or Fabric directly.
2. Workaround: Join with the Picklist Metadata
You can pull the picklist values from the Salesforce metadata API and join them manually in Power BI. It’s a bit of a pain, but works.3. Use a custom SOQL query (if supported)
If your connector allows custom SOQL, you can write a query that includes both ID and label fields (some standard fields support this).Let me know which connector you’re using (Power BI, Fabric Dataflow, etc.) – I can give a more specific example.
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
