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

[PraveenM07]

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 fields to my visulization. 

Its basically I have a dashboard of shipment tracking details of various forwarders I have to show the entire journer of a shipment there when I use slicers to filter tracking number I need to pull relevent JSON file named with the same tracking number from the Azure data lake and go through a same query function

[Anonymous · Accepted solution]

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.