Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I'm connecting to Salesforce with no issues. And I can connect to an 'standard' object without issues. But certain objects require that you filter on certain fields as part of the initial query. The error you get if you run a query such as
SELECT Id from CONTENTDOCUMENTLINK
is "ContentDocumentLink requires a filter by a single Id on ContentDocumentId or LinkedEntityId using the equals operator or multiple Id's using the IN operator." Similar errors are "a filter on a reified column is required [EntityDefinitionId,DurableId]" (when attempting to SELECT Id from FieldDefinition).
For the latter, a working query would be SELECT Id from FieldDefinition where EntityDefinition.name = 'Account'
How can I get Power Query (in Excel) to only request the latter query? I tried
let
Source = Salesforce.Data("https://test.salesforce.com", [ApiVersion=48]),
FieldDefinition = Source{[Name="FieldDefinition"]}, {[Name="FieldDefinition"]}[Data],
FieldDefinition2 = Table.SelectRows(FieldDefinition, each "EntityDefinitionId" = "Account" )
in
FieldDefinition2
but it only generates the column names and no data.
I got it to work with with code, the trick was to use brackets:
let
Source = Salesforce.Data(#"URL", [ApiVersion=48]),
FieldDefinition = Source{[Name="FieldDefinition"]}[Data],
FieldDefinition2 = Table.SelectRows(FieldDefinition, each [EntityDefinitionId] = "Account" )
in
FieldDefinition2
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 10 | |
| 6 | |
| 5 | |
| 5 | |
| 2 |