Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Sign up nowGet Fabric certified for FREE! Don't miss your chance! 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.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |