Power Query function · Free
ECB currency rates
Load euro reference rates with a clear conversion direction.
Review build. Scoped native checks are listed under What you need. Full acceptance is incomplete. Purchases are disabled.
Will it fit your work?
- Your input
- A date range and optional supported currency codes.
- Your result
- PerEUR, EURPerUnit and publication date; optional weekend carry-forward.
- What you need
- Power Query and anonymous access to data-api.ecb.europa.eu. Power BI Desktop (17 Oct 2026): 6 live and 4 offline scenarios passed. Excel Power Query (19 Oct 2026): the 4 offline and 6 live scenarios passed. Live refresh in the Power BI Service not yet tested.
- Check this first
- Multiply foreign-currency amounts by EURPerUnit to get EUR. A missing currency is not a zero rate.
Start with one known example
- Extract the whole ZIP and read START_HERE.md.
- Start with
ECB_FX.pqon a copy. - Use the example below; replace input paths and settings.
- Reconcile rows and totals before using real data.
ECB_FX(#date(2026,1,1), #date(2026,1,31), {"USD", "CZK"})Each package includes the source file or workbook, its PDF guide, a short setup path, verification status and a support checklist.
Free builds are for evaluation; validate the result in your own environment. Price shown for a paid tool is the proposed one-time price, before any applicable checkout taxes.
Data stays in your own files except for configured service calls. VIES receives VAT numbers; currency services receive requested dates and currency codes. No tracking or signup is used by this static preview.