Goal: We want to see a simple report with currency rates concerning the Polish currency – Polish złoty (PLN). We would like to have a possibility to see which countries make use of which currency.
Let’s see if we can find another path to success, but this time we will make use of data virtualization capabilities of Lyftrondata.
A Lyftrondata-based approach utilizing data virtualization
Similar to PowerBI, at the beginning, we need to establish connections to data sources. Let’s connect to Fixer.IO source: we need to select JSON data provider and enter URL and JSON path to the repeating element, which in our case is just “$” (the root):