How to reload the input data to show the data distributions of all data in preview in Tableau Prep Builder without reopening the flow?
When openning a flow which has more than 1 million rows (for this example, it is 5.73 million rows) and has been set to [Use all data] under [Data Sample] pane on Input Step, at this time we can see the data distributions of all data in preview of clean step like below.
After start editing the flow, the data distributions in preview of clean step is limited to 1 million size like below.
However, sometimes we want to review the data distributions of all data in preview of clean step to confirm if our flow is edited as expected.
Is there any way to review the data distributions of all data in preview of clean step again without reopening the flow?
There is a workaround to reload the all data again without reopening the flow.
Note: Please save your flow editing work before you try the workaround since to using [Use all data] can impact performance or cause Tableau Prep Builder to time out.
=====
1. In Tableau Prep Builder, at Input Step, confirm your current [Data Sample] setting is [Use all data].
2. In the same Input Step, change [Data Sample] setting to [Fixed number of rows], and keep the row limit value as blank.
3. In the same Input Step, change [Sampling method] from current one to another one.
In this example, change it from [Random sample] to [Quick select].
4. Confirm the [Data Sample] setting is returned back to [Use all data] automatically.
Note: By design, when changing [Sampling method] with the row limit value as blank, this setting is invalid and returned back to previous [Data Sample] setting.
5. Return to the clean step which you want to review the data distributions of all data, then wait till the data loading is finished.
6. Confirm the data distributions shows all data size again.
001462820

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.