Data Flow's Conditional Split transform step doesn't show Data Preview for all cases; drop down selector is blank

Question

Data Flow's Conditional Split transform step doesn't show Data Preview for all cases; drop down selector is blank

Jeff vG 96

I have a Conditional Split transform feeding three branches, one of which has multiple streams to write to multiple different tables, like so:

But when I run Data preview in Debug mode, it won't show me any preview except the top-most case, and doesn't switch if I click another case and rerun the preview task - same result only. Any suggestions?

Jeff vG 96 Reputation points

2021-06-29T15:30:56.453+00:00

For posterity: this seems to be an intermittent issue. I'm not sure what causes the drop-down to fail to load, but I can currently see the 3 different output streams and their previews. Interestingly, the previews are not always correct for the given output stream, and I've flipped back and forth between them a few times now with differing row counts (from 2 to 21) for the same output stream.
ShaikMaheer-MSFT 38,636 Reputation points Microsoft Employee Moderator

2021-07-01T06:04:47.437+00:00

Hi @Jeff vG ,

Following up to check is below provided answer helps. Please Accept Answer if that helps. Accepting answer will help us and community too. Thank you.
ShaikMaheer-MSFT 38,636 Reputation points Microsoft Employee Moderator

2021-07-02T10:04:12.007+00:00

@Jeff vG ,

Just checking is provided answer helped you? Please Accept Answer. So that community will get benefit from it. Thank you
ShaikMaheer-MSFT 38,636 Reputation points Microsoft Employee Moderator

2021-07-05T11:04:26.287+00:00

Hi @Jeff vG ,

Could you please accept below provided answer if that works for you. Accepting answer will help community. Thank you

1 answer

Your answer

Jeff vG 96 Reputation points

2021-06-29T15:30:56.453+00:00

For posterity: this seems to be an intermittent issue. I'm not sure what causes the drop-down to fail to load, but I can currently see the 3 different output streams and their previews. Interestingly, the previews are not always correct for the given output stream, and I've flipped back and forth between them a few times now with differing row counts (from 2 to 21) for the same output stream.
ShaikMaheer-MSFT 38,636 Reputation points Microsoft Employee Moderator

2021-07-01T06:04:47.437+00:00

Hi @Jeff vG ,

Following up to check is below provided answer helps. Please Accept Answer if that helps. Accepting answer will help us and community too. Thank you.
ShaikMaheer-MSFT 38,636 Reputation points Microsoft Employee Moderator

2021-07-02T10:04:12.007+00:00

@Jeff vG ,

Just checking is provided answer helped you? Please Accept Answer. So that community will get benefit from it. Thank you
ShaikMaheer-MSFT 38,636 Reputation points Microsoft Employee Moderator

2021-07-05T11:04:26.287+00:00

Hi @Jeff vG ,

Could you please accept below provided answer if that works for you. Accepting answer will help community. Thank you

Answer 1

ShaikMaheer-MSFT 38,636 Microsoft Employee Moderator

Hi @Jeff vG ,

Thank you for posting your query in Microsoft Q&A. Yes, it looks like an intermittent issue.

If you face any such strange intermittent issue while data previewing. Please try to modify source transformation name(for example, source1 to source2 something like that) and then try data preview again. That will help to overcome.

Hope this will help.

--------------------------------

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
Want a reminder to come back and check responses? Here is how to subscribe to a notification.

Syed Althaf 1 Reputation point

2021-08-30T17:36:44.407+00:00

Hey Maheer,

Thanks..Renaming the output stream names has helped me in getting in resolving this issue.
ShaikMaheer-MSFT 38,636 Reputation points Microsoft Employee Moderator

2021-08-31T03:58:40.467+00:00

Hi @Syed Althaf ,

Thank you for sharing your work around.

Share via

Data Flow's Conditional Split transform step doesn't show Data Preview for all cases; drop down selector is blank

1 answer

Your answer