Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Specifies the child element for a fetch element, the 'parent entity' for the query. Only one entity is allowed.
Learn how to query data using FetchXml.
<fetch>
<entity name='account'>
<attribute name='accountclassificationcode' />
<attribute name='createdby' />
<attribute name='createdon' />
<attribute name='name' />
</entity>
</fetch>
Name | Required? | Description |
---|---|---|
name |
Yes | The logical name of the table that the query is based on. |
Name | Description |
---|---|
fetch | The root element of a FetchXml query. |
Name | Occurrences | Description |
---|---|---|
all-attributes | 0 or 1 | Indicates that all non-null column values for each row are returned. It is the same as not adding any attribute elements. We don't recommend using this element for most cases. |
attribute | 0 or many | Specifies a column from an entity or link-entity to return with a query. |
order | 0 or many | Specifies a sort order for the rows of the results. |
link-entity | 0 or many | Joins a table related to the entity or link-entity to return more columns with the result. |
filter | 0 or 1 | Specify complex conditions for an entity or link-entity to apply to a query. |
Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn more