Unable to preview data in flatten activity in dataflow

Kumar, Arun 336 Reputation points
2023-01-14T06:37:16.1866667+00:00

I am getting below error with no description while trying for flatten json

User's image

I am able to inspect columns

User's image

No output data in Source also

User's image

But i can see preview data in json format in the connection

Any idea whats going wrong here?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,696 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Vinodh247 13,801 Reputation points
    2023-01-15T10:23:40.13+00:00

    Hi

    Thanks for reaching out to Microsoft Q&A.

    Are you sure it is json file type? from the screenshare you have shared the 'getjson' activity couldn't read the file and subsequently couldn't preview also. Have you tried raising a support ticket with microsoft? if not I would advise you to check and confirm and then raise a feature request.

    Please Upvote and Accept as answer if the reply was helpful, this will be helpful to other community members.

    0 comments No comments