Use FXMacroData in Power BI
Build refreshable macro dashboards in Power BI Desktop with FXMacroData API endpoints. Start with the built-in Web connector and Power Query M before considering a custom connector.
Use built-in tools
Power BI's Web connector can load FXMacroData JSON endpoints directly.
Refreshable reports
Create scheduled dashboards for policy rates, inflation, FX rates, and release dates.
Connector later
A custom connector is useful later, but Web + Power Query is the fastest first path.
Power BI Web connector
- Open Power BI Desktop.
- Select Get data > Web.
- Paste a production FXMacroData API URL.
- Use Power Query to expand the JSON
datafield into rows. - Set refresh cadence according to endpoint cache behavior and your API plan.
Policy-rate series
https://fxmacrodata.com/api/announcements/usd/policy_rate
Upcoming release calendar
https://fxmacrodata.com/api/calendar/usd
Power Query M example
let
Source = Json.Document(Web.Contents("https://fxmacrodata.com/api/calendar/usd")),
Rows = Source[data],
CalendarTable = Table.FromRecords(Rows)
in
CalendarTable
Localized values for locale dashboards
Show the original published value in Power BI visuals, then add localized unit or currency comparison without hiding the source publisher format.
Source
Rs. 75 per litre
Comparison
$3.41 per gallon
Local number system
Monthly household spend: Rs. 120,000
Locale routes should preserve the source value and add unit or currency comparison views without hiding the original publisher format.
Dashboard ideas
G10 policy-rate monitor
Load policy-rate endpoints for USD, EUR, GBP, JPY, AUD, CAD, CHF, and NZD, then compare latest values and change history.
Release calendar board
Load calendar endpoints by currency and create a date-sorted board for upcoming CPI, GDP, employment, and central-bank releases.
Inflation dashboard
Track CPI paths by country, compare latest prints, and flag acceleration or disinflation across regions.
FX context report
Join FX spot history with policy-rate and inflation series for pair-level research dashboards.
Refresh and authentication notes
- Public examples are useful for first setup and dashboard prototypes.
- Protected endpoint families require an API key. Public docs use query-parameter authentication for copy-paste examples.
- Use refresh intervals that match the business cadence of macro releases. Most macro series do not need minute-by-minute refresh.
- Keep API keys out of shared screenshots and published `.pbix` files.