SELECT COUNT only gives 1000 in lakehouse query

[romankorchak]

Hi All

May not be the right forum, but I couldnt find Lakehouse one so posting it here

I have a Dataflow gen2 that adds few thousands rows to a datalake table everyday, and I tried to check he total quantity of rows with SELECT COUNT(*) sql query but it only shows 1000 rows 😞
Any idea how to remove that 1000 limit?

Thanks

[romankorchak]

It wasnt SELECT COUNT, it was just api giving only 1000 items 🙄

[v-nikhilan-msft]

Hi @romankorchak 
Thanks for using Fabric Community.
I tried to repro the above mentioned scenario. I have a table named Covid_table in Lakehouse. It has more than 1000 rows. When I execute the select count(*) query, I am able to get the exact number:

Can you please try to execute the query again? Please let me know if the issue persists.

[v-nikhilan-msft]

Hi @romankorchak 
We haven’t heard from you on the last response and was just checking back to see if your query got resolved. Otherwise, will respond back with the more details and we will try to help.
Thanks

[v-nikhilan-msft]

Hi @romankorchak 
We haven’t heard from you on the last response and was just checking back to see if your query got resolved. Otherwise, will respond back with the more details and we will try to help.
Thanks