Direct Import from Data Warehouse not returning all data

[Housden996]

Hi 

I am connected to a Data Warehouse via Direct Query and it isnt pulling in all records.

My Direct Query is only retunring 1.32 Million records, the same connection via import retuns 4.32 Million records.

Why is my Direct Query not returning all data?

Thanks

Alx

[Housden996 · Accepted solution]

Ended up be a capacity issue which was solved by Microsoft

[rajendraongole1]

Hi @Housden996 - you can check on data source for any row limits or timeouts when you are extracting from DQ. Adjust the settings if necessary. Long-running queries might time out, causing incomplete data retrieval. Some databases have default settings or limitations on the number of rows returned.

check on the databases side.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[Housden996]

Thanks, for a Fabric Data Warehouse where do I see this, I cannot see anything in the settings, does this have to be done by an admin?