Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi Experts,
I am searching for hours, watching tutorials and also have no idea how to get the right answer. So I hope you can help me:
I want to get the informations of this website per API: Documentation | Exchange Rates API,
e.g. for the latest prices. So thats the documentation:
https://api.exchangeratesapi.io/v1/latest
? access_key = API_KEY
& base = USD
& symbols = GBP,JPY,EURAt first I try to connect the Webservice with the surface of power BI, but this didn't work because of the name of the key ( access_key) instead of Authorization. Now my plan was to take the code, how it was offerd in the blog (Power Query Web.Contents cheat sheet walkthrough | by Oscar Martinez | PowPCo) at Example No. 5 but i don't get it. How I can adress the freaking name of the token?
It seems to me something like :
let
Source = Json.Document(
Web.Contents(
"https://api.exchangeratesapi.io/v1/latest",
[
Query = [
access_key = "123"
]])),
in
Source
or
let
Source = Json.Document(Web.Contents(
"https://api.exchangeratesapi.io/v1/latest",
Query =[
ApiKeyName="access_key",
apikey = "123"
]
))
in
Source
In this solution I should only set the "Key Name" and set the Key at the login screen. But It also did not work. Is the key incorrect or did I some mistakes?
Get Data through API - Microsoft Power BI Community
Code:
let
Source = Json.Document(Web.Contents(
"https://api.exchangeratesapi.io/v1/latest",
[
ApiKeyName="? access_key"]
))
in
Source
Screen:
The Key "123" is only for the understanding.
Thanks a lot 😭
Your first option is most appropriate but you are missing the other query components. You need to supply base and symbols too.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 1 |
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 3 |