Forum Discussion

PraveenM07's avatar
PraveenM07
New Member
2 years ago
Solved

Need to get JSON files from Azure Data Lake dynamically when file name was input into a slicer

I need to import set of JSON files from Azure Datalake Dynamically when the file name was input into a slicer. Then the JSON file should be processed with a same query where I can get the needed fiel...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi PraveenM07 ,

     

    Use Azure Data Factory (ADF) to create a pipeline that can dynamically load JSON files from Azure Data Lake Storage Gen2 based on a parameter. You can leverage the Copy Data activity in ADF, configuring the source to filter files using the wildcard file path option to match your tracking number pattern. For more details on configuring the Copy Data activity, refer to the documentation Configure Azure Data Lake Storage Gen2 in a copy activity - Microsoft Fabric | Microsoft Learn

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi PraveenM07 ,

 

Use Azure Data Factory (ADF) to create a pipeline that can dynamically load JSON files from Azure Data Lake Storage Gen2 based on a parameter. You can leverage the Copy Data activity in ADF, configuring the source to filter files using the wildcard file path option to match your tracking number pattern. For more details on configuring the Copy Data activity, refer to the documentation Configure Azure Data Lake Storage Gen2 in a copy activity - Microsoft Fabric | Microsoft Learn

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.