Share via

Dataflow Data Preview shows no data, large table as data source

Francisco Dominguez 386 Reputation points
2021-12-22T15:42:18.217+00:00

Hi,

I have a dataflow that has a SQL as source. In this source, I use the data preview feature and it shows data as normal. Right after that source, I have a filter activity that filters by a certain date range.

This filter activity is showing no rows in the data preview tab. I've checked with my SQL table, and there is data for the date range I'm filtering by in the filter activity.

This SQL table has a lot of rows. This is almost 4 million rows. Is this an issue?

If not, why isn't the activity showing the data preview?

Thanks.

Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Francisco Dominguez 386 Reputation points
    2021-12-23T07:41:57.81+00:00

    I saw yesterday it was defaulted to 1000. I bumped it to 1000000 but was still not working, so I went ahead and used the full 4 million rows and it worked.

    I didn't know it worked that way.

    Thank you!

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.