How to write query to fetch count of an entity from Dataverse

[PriyaJha]

Hi All,

I have a linked service connecting to Dataverse and i want to fetch count of table/entity from Dataverse.

How to write query to fetch only count of table from Dataverse.

[V-yubandi-msft]

Hi @PriyaJha ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution we provided for your issue worked for you  or let us know if you need any further assistance?

Your feedback is important to us, Looking forward to your response. 

Thank You.

[V-yubandi-msft]

Hi @PriyaJha ,

We noticed we haven't received a response from you yet, so we wanted to follow up and ensure the solution we provided addressed your issue. If you require any further assistance or have additional questions, please let us know.

Your feedback is valuable to us, and we look forward to hearing from you soon.

Thank You.

[V-yubandi-msft]

Hi @PriyaJha ,

Thank you for reaching out to the Microsoft Fabric Community.

The @NandanHegde , has shared an  solution that should address your query. Could you please confirm if it worked for you?

If you need any further clarification or additional details, feel free to let us know. We’re ready  to assist.

If your issue is resolved, please mark the response as the Accepted Solution to help others in the community easily find the answer.

Thank You.

[NandanHegde · Accepted solution]

You can use the below query :

FetchXML structure:

<fetch aggregate='true'>
<entity name='<<tableName>>'>
<attribute name='<<primaryKeyAttribute>>' alias='count' aggregate='countcolumn' />
</entity>
</fetch>