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.
Hello
I have this url
https://api.statbank.dk/v1/data
and I want to use this request for getting data for PowerBI.
{
"table": "ls01",
"format": "CSV",
"valuePresentation": "Value",
"timeOrder": "Ascending",
"delimiter": "Semicolon",
"variables": [
{
"code": "BRANCHE",
"values": [
"*"
]
},
{
"code": "ENHED",
"values": [
"*"
]
},
{
"code": "Tid",
"values": [
"2010",
"2018"
]
}
]
}
I have never used API's for getting data into PowerBI, hence a step-by-step guide would be very much appreciated!
Thank you 🙂
Hi @MFester ,
Basically you can use Web.Contents to call the API like below
let
Source = Json.Document(Web.Contents("https://api.statbank.dk/v1/data"))
in
Source
Please refer the below link
https://community.powerbi.com/t5/Developer/Connecting-to-web-api/td-p/775075
User | Count |
---|---|
5 | |
4 | |
3 | |
2 | |
2 |
User | Count |
---|---|
8 | |
6 | |
4 | |
4 | |
4 |