Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
kris10me
New Member

Currency Converter

I am creating a dataflow that should pull updated conversion rates every day when it refreshes.  I created a function with the API information that looks like this:  

kris10me_0-1693337727456.png

Then created a query like this:

let
  Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("VZZRjqMwEETvMt97CRIYE7CBsXEIrPb+11iNS5SqvqInm3bTtDvv79+voeavP1+19F///vz96r4XpRiF+qsXOsquO9dO6PPUnV0uSsnWjqBUbe3SXB5F1x6jUa+5PB62dloUe4fP+q1rltljt+fWh1D1XLqkdGxKWSv4WOy5YCe8NJfnexCaR/1Gn852dhpzPpWeUXN5LqfSqmtzspi9UX4qVX2uW/T7Pa9Z+2U2mjRmb6cPwShrXcqlFRx2/Q7fsz73Pdm33fS8YN82DBozjNqf4aUxw/6jZHmGxU6wyo+71mVc9Lxxtp1Vo7yK1uy16Hd/9UbZ6EdjvpLm+Yr6fpNVYtq0J6ZBn5tW66xL79g8aMx5O5Sy0WFRgj4XO33b+NDTY9GaxaxRonf5qBVM1lkp6FxKh56XTq1gehvlqmQzMn20P1OveaZFq5TsbiabZylpLovtXDY9b7GZtbxWJZshy6ox16RRttko6M7t1G7dBo25jVrPLeraT2d1sb7Oq+7MVe9tPvSLFTuh2NwtdkK2uVueulaiTswSbKf9I5RVe/CyE4L1YCnWkVbB0mvNivVnGbS65dQou92HfdJc9sto1Jrt1tf7blHsf2XPeqf3pB1Zw0epG3WWDxqlnnoDqmX2rm8lmwVvy+UctGZX0skA8/itVTu9mQepmcdNMI+bYB7c2czjJpgH15p5kJKtNfMgVVu7NBeYB2k06jUXmAfptCj2DjAPrllmMA9SM4+bqufSzIPUzIOUtYIwD1KwE16aC8zjJpgHs+5sZ6cxYR5ci5oLzIO06hrMg2u9UTMPUtXnYB5ca+bBfpmNJo3Z2+kwD1LWusA8uLbrd4B5kCb7tpueF+zbwjxIo/YnzIPUzINkecI8SFZ5mAdp0fNgHqSqUWAepEW/O8yDlI1+NCbMgxT1/SarBMyDNOhzMA92yKV3DOZBauZBykaHRQn6HMyD9NDTYR6krFGid/moFUzWWTAP0qHnwTxIb6NmHiSbkTAPUq95wjxIdjeTzTOYx02L7YR5kGxmwTxINkNgHjfBPG6CeZCC7oR5kAaNCfMgRV2DefCNrK9hHqSq9xbmwRtuJxSbu8VOyDZ3YR6kqBMT5kGyfwSYx02XnRCsB2Ee7DqrIMyDZP35+yt0apTd7gPMg3QZjVqz3foa5kGy/xWYBylpR8I8SM08OMsHjQLzIFlmMA+SzYK35QLzYK2TTga4xq9/NGqucRNc4ya4Bnc217gJrsG15hqkZGvNNUjV1i7NBa5BGo16zQWuQTotir0DXINrlhlcg9Rc46bquTTXIDXXIGWtIFyDFOyEl+YC17gJrsGsO9vZaUy4Btei5gLXIK26BtfgWm/UXINU9Tm4Bteaa7BfZqNJY/Z2OlyDlLUucA2u7fod4Bqkyb7tpucF+7ZwDdKo/QnXIDXXIFmecA2SVR6uQVr0PLgGqWoUuAZp0e8O1yBlox+NCdcgRX2/ySoB1yAN+hxcgx1y6R2Da5Caa5Cy0WFRgj4H1yA99HS4BilrlOhdPmoFk3UWXIN06HlwDdLbqLkGqdraR/sTrkFatErJ7mayeQbXuGmxnXANks0suAbJZghc4ya4xk1wDVLQnXAN0qAx4RqkqGtwDb6R9TVcg1T13sI1eMPthGJzt9gJ2eYuXIMUdWLCNUj2jwDXuOmyE4L1IFyDXWcVhGuQrD/hGqRTo+x2H+AapMto1Jrt1tdwDZL9r8A1SEk7Eq5Baq7BWT5oFLgGyTKDa5BsFrwtF7gGa504Gf79Bw==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [From = _t, To = _t]),
 #"Add Column" = Table.AddColumn(Source, "Rate", each GetExchangeRate([From],[To]))

in
#"Add Column"

 

 

Which gives me a table like this:

kris10me_1-1693337812405.png

When i click on [Record], it gives me this output

kris10me_2-1693337854383.png

 

The issue with this is that i need every currency type converted to USD, EUR, and SEK.  This last screenshot is the entire output it is giving me (not even close to complete).  

 

I just need a table with 3 columns.  To, From, Rate

ex......   USD, EUR, 1.25

 

1 REPLY 1
ToddChitt
Super User
Super User

Don't click the Record in a row, click the double headed arrow at the top of the Rate column. That will allow you to expand and pick which column you want to add. I bet Rate is one of those available.




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.