Azure Data Factory: No data when trying to preview data source

Question

Azure Data Factory: No data when trying to preview data source.

Data is present at source and even when we minimize the browser to 30% we are able to see data in data preview but when we are doing normal data preview we are unable to see any data in all the data flows.

Data is present in ADLS gen2 location.

Unable to see data in Data preview in Azure Data factory's Dataflow.

Answer 1

Hi Koli,Sonia,

You can try the following below to resolve the issue.

1. Check Dataset Connections: Ensure that the dataset connections are correctly configured and that the linked service is properly set up.
2. Test Connections: In the data flow designer, go to each source and sink transformation and test the connections.
3. Debug Mode: Use debug mode to see if there are any errors or warnings that might give more insight into why the data isn't showing up.
4. Re-import Schema: Sometimes, re-importing the schema can help resolve issues. Remove the current schema and import it again.
5. Check Compute Resources: Ensure that the compute resources allocated for the data flow are sufficient. Sometimes, insufficient resources can cause issues with data preview.
6. Transient Issues: There might be transient issues with the services involved in the execution. Configuring retries in the pipeline activity can help resolve these issues.

Below are two useful url link from microsoft documentation.

https://learn.microsoft.com/en-us/answers/questions/1608892/azure-data-factory-no-data-when-trying-to-preview

https://learn.microsoft.com/en-us/azure/data-factory/data-flow-troubleshoot-guide