Forum Discussion
Direct Import from Data Warehouse not returning all data
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
Ended up be a capacity issue which was solved by Microsoft
3 Replies
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!!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?
Ended up be a capacity issue which was solved by Microsoft
