Microsoft Fabric · Market Risk

Market Risk Intelligence Feed — FX Rate Ingestion & Backfill

Global Credit Corp

Project overview

Replaced manually keyed spreadsheet FX rates with a warehouse-native Fabric feed — REST API calls, T-SQL OPENJSON parsing, and an idempotent stored procedure that supports safe replay and historical backfill.

Tech stack

Fabric WarehouseREST APIOPENJSONT-SQL Stored ProcedureIdempotent Load

Discuss this project

More case studies

Power BI · Renewables

Generation & Revenue Performance Dashboard

Automation · Power Query

Automated Reporting Pipeline

Forecasting · Wind & Solar

Forecast Accuracy Improvement Programme