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

Get Fabric certified for FREE! Don't miss your chance! Learn more

Reply
DanielSchauerTa
New Member

Error Bringing in Salesforce PicklistValueInfo into Power Query

I have a large Salesforce application that I want to query with Power Query. I am able to pull in many of my objects without any issues. However, some objects contain dropdown fields whose available values come from a Salesforce object named PicklistValueInfo. When I attempt to add that object, I get an error (see below). How can I bring this lists data into Power Query?

 

DataSource.Error: PicklistValueInfo: a filter on a reified column is required [EntityParticleId,DurableId] Details: [List]

 

DanielSchauerTa_0-1675971297011.png

 

2 REPLIES 2

@RM7 appreciate your intention to help. Please clearly state that the windsor.ai connector comes with a cost, comes with a requirement to allow a third party to access Salesforce on your behalf, and is not functionally different from the regular SFDC API.

lbendlin
Super User
Super User

reify:  

  • transitive verb To regard or treat (an abstraction) as if it had concrete or material existence.

 

The what now?!?

 

You can raise an issue at https://issues.powerbi.com . If you have a Pro license you can consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.