Forum Discussion
Solved
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 Mil...
Ended up be a capacity issue which was solved by Microsoft
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?