Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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,EUR
At 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.
User | Count |
---|---|
5 | |
4 | |
4 | |
2 | |
2 |
User | Count |
---|---|
8 | |
6 | |
4 | |
4 | |
4 |