Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedJoin us at the 2025 Microsoft Fabric Community Conference. March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for $400 discount. Register now
Newbie here!
I would like to establish an action that I couldn't find a way or answer.
The purpose is to load a list of specific table names from one source of data.
This list is subject to change (new/modify/delete values).
Example, list of tables:
What is the best approch?
Regards,
Théo
Solved! Go to Solution.
Hello @Theo_MS
To dynamically load a list of tables in Microsoft Fabric pipelines with changing table names, use a metadata-driven approach with Lookup and ForEach activities
1 Retrieve Table Names with a Lookup Activity
Use a query or stored procedure to fetch the latest table list from your source system:
Store your table names in a configuration table for easier updates
Ensure the Lookup returns results as an array (e.g., `@activity('Lookup1').output.value`)
Iterate with ForEach Activity
Configure the ForEach activity to process each table
Iterate with ForEach Activity
Configure the ForEach activity to process each table
"items": "@activity('Lookup1').output.value"
1. Lookup Activity (Get Table List)
2. ForEach Activity (Iterate Tables)
If Activity (Filter Table)
Copy Data Activity (Valid Tables)
Optional: Logging Activity (Skipped Tables)
https://github.com/Azure/AnalyticsinaBox/tree/main/Fabric/src/deployment/Pattern1and2
if this is helpful please accept the answer
Hello @Theo_MS
To dynamically load a list of tables in Microsoft Fabric pipelines with changing table names, use a metadata-driven approach with Lookup and ForEach activities
1 Retrieve Table Names with a Lookup Activity
Use a query or stored procedure to fetch the latest table list from your source system:
Store your table names in a configuration table for easier updates
Ensure the Lookup returns results as an array (e.g., `@activity('Lookup1').output.value`)
Iterate with ForEach Activity
Configure the ForEach activity to process each table
Iterate with ForEach Activity
Configure the ForEach activity to process each table
"items": "@activity('Lookup1').output.value"
1. Lookup Activity (Get Table List)
2. ForEach Activity (Iterate Tables)
If Activity (Filter Table)
Copy Data Activity (Valid Tables)
Optional: Logging Activity (Skipped Tables)
https://github.com/Azure/AnalyticsinaBox/tree/main/Fabric/src/deployment/Pattern1and2
if this is helpful please accept the answer
Hi @nilendraFabric,
thanks for you explanation and steps.
Currently in pipeline, it seems impossible to use a stored procedure created in a Lakehouse.
The "stored procedure" activity accepts only Warehouse.
How can I store table names in a configuration in a Lakehouse?
Do you have different proposal ?
Regards,
Théo
Add a Lookup activity to your pipeline:
• Source: Lakehouse table `config_table`.
• Configure to return all rows (not just the first)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Fabric update to learn about new features.
User | Count |
---|---|
8 | |
2 | |
1 | |
1 | |
1 |