Power BI में FXMacroData का उपयोग करें
Power BI Desktop में FXMacroData API endpoints के साथ refreshable macro dashboards बनाएँ। built-in Web connector और Power Query M से शुरू करें, और locale routes पर source value, local numbering और comparison views को साथ रखें।
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
Power BI visuals में वही value स्थानीय रूप में दिखाएँ जो source publisher ने प्रकाशित की है, लेकिन comparison unit और local number formatting के साथ।
Source
Rs. 75 per litre
Comparison
$3.41 per gallon
Local number system
Monthly household spend: Rs. 1.2 लाख
Locale routes should preserve the source value and add a locally familiar number system such as lakh/crore where it improves comprehension.
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.