Process Hub · Connections and lookup sources
How to configure and refresh process lookups
Stage approved lookup data and verify that process fields can use it.
On this page
Before you start
- Configure and test the profile runtime SQL target and Lookup Lakehouse first. Have the required connection/data-management permissions and know the intended source table/columns.
Follow these steps
- Open Settings → Process Hub → Lookups and select Add lookup.
- Choose the Source table and required columns. Give it a clear Lookup name and review the runtime-table information before saving.
- Save the lookup definition, then use its available sync/refresh action and inspect Status, Last sync and row results.
- Open Lookup automation for recurring refreshes. Enable scheduled sync and set frequency, start time and Time zone; save the settings.
- If a Fabric pipeline must signal completion, enable Fabric API trigger and save. Give the one-time credential and receiver instructions securely to the integration owner; do not expose them to process users.
- Configure the process field to use the intended lookup and test its allowed values/filters in a deployed runtime. Source data changes appear after a successful refresh.
What you should see
The lookup’s selected data is available in runtime and has an explicit refresh plan.
If something goes wrong
Storage required appears
Return to Fabric setup and configure/test both required sources.
New values are missing
Review Recent syncs, source table/column selection and field filters. A pending/failed sync has not refreshed the runtime data.
You are considering Remove
Lookup removal can permanently remove its runtime table and sync history. Review dependent fields/processes with the data owner before any deletion.