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
Hi,
I'm using Power Query to make a API Request call. I'm facing the below error. Please advice.
let
body = "{
""method"": ""post"",
""params"": {
""grant_type"":""password"",
""username"": ""****"",
""password"": ""***""
}
}",
Source = Json.Document(Web.Contents("****", [Headers=[Authorization= "Basic ZUU1aFBpbWxVSjJjRDFmbGU5WGNMMF9mbW1ZYTpIQnk5TDExam14ZnVmRGYyVmxfTnZJbWVIM1lh",
CacheControl="no-cache", ContentType="application/x-www-form-urlencoded"], Content=Text.ToBinary(body)]))
in
#"Source"
I'm facing the below error:
DataSource.Error: Web.Contents failed to get contents from '***' (415): Unsupported Media Type
Details:
DataSourceKind=Web
Thanks
Hi @Anonymous ,
Does this API have api key? If does, you could use key to replace username and password and check if it works.
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 |
|---|---|
| 9 | |
| 7 | |
| 7 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 21 | |
| 14 | |
| 11 | |
| 10 | |
| 9 |