Power BI Connector for Open Exchange Rates

Build 21.0.7930

Latest

Query the Latest exchange rates available from Open Exchange Rates.

Table Specific Information

Select

Select all of the Latest exchange rates:

SELECT * FROM Latest

Select from the Latest exchange rates by specifying Symbols in a comma-separated list:

SELECT * FROM Latest WHERE Symbols='ALL,AUR,GBP' 

Columns

Name Type References Description
Currency String Currency (3-letter code).
Value Decimal Rate for the currency.
Base String Base currency (3-letter code. Default: USD).

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Symbols String Limit results to specific currencies (comma-separated list of 3-letter codes).

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930