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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello All ,
I need to get data from this web call :
the blank space are names of company .
The Headers are :
#"Accept" = "application/json",
#"connector-name" = "sql",
#"Content-Type" = "application/json"
The Body :
{ "parameters": [ { "LIMIT": "55" }, { "OFFSET": "0" } ] }
Furthermore I have an Authorization Key .
I wrote this in advance editor :
let
Key = "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
URL = "",
headers=
[
#"Authorization" = Key,
#"Accept" = "application/json",
#"connector-name" = "sql",
#"Content-Type" = "application/json"
],
Body=
"{""parameters"": [{""LIMIT"": ""55""},{""OFFSET"": ""0""}]}",
source = Json.Document(Web.Contents(URL, [Headers = headers,Content = Text.ToBinary(Body)]))
in
source
But it doesnt work : "name could not be resolved"
Whereas when I test this api call online works :
Body :
Key :
Headers :
Works :
Could someone help me ?
Thank you
I tried as well in Postman :
In Api Key Value I pasted the key .
Here the headers :
Then the body :
When I send the call is working :
Could someone help me ?
Thank you
Hello , any help ? 😭
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 7 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 24 | |
| 15 | |
| 14 | |
| 12 | |
| 9 |