question

JeffvG-0844 avatar image
0 Votes"
JeffvG-0844 asked ShaikMaheer-MSFT commented

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

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

110269-image.png

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?

110313-image.png


azure-data-factoryazure-synapse-analytics
image.png (23.7 KiB)
image.png (37.6 KiB)
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·

Hi @JeffvG-0844 ,

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.

0 Votes 0 ·

@JeffvG-0844 ,

Just checking is provided answer helped you? Please Accept Answer. So that community will get benefit from it. Thank you

0 Votes 0 ·

Hi @JeffvG-0844 ,

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

0 Votes 0 ·

1 Answer

ShaikMaheer-MSFT avatar image
0 Votes"
ShaikMaheer-MSFT answered ShaikMaheer-MSFT commented

Hi @JeffvG-0844 ,

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

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hey Maheer,

Thanks..Renaming the output stream names has helped me in getting in resolving this issue.

0 Votes 0 ·
ShaikMaheer-MSFT avatar image ShaikMaheer-MSFT AlthafAspiringAzureDataEngineer-1696 ·

Hi @AlthafAspiringAzureDataEngineer-1696 ,

Thank you for sharing your work around.

0 Votes 0 ·