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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello,
Little bit of a weird but a small question.
In my function Web.Contents I make a call to an URL which is a simple login page. If you go to the login page when opening the URL it works without error and shows a simple status code like 200. If in Power BI I use anonymous as authentication it works, but it also works when I use basic authentication with a username and password. When I use anonymous my RelativePath won't work because it requires basic authentication to call the API.
let
HTTPHeader = [RelativePath = "api/Plannings/GetList", Query = [page="0", pageSize="0", departmentShortName="", departmentExternalCode="", resourceId="", dateFrom="", dateTo="", projectId="", taskId="", lastModifiedDate=""], Headers = [#"Content-Type"="application/json"]],
GetPlannings = Json.Document(Web.Contents("https://BLUH.ionbiz.com", HTTPHeader))
in
GetPlannings
Kind regards
Hi @naelske_cronos ,
Hope this article can help you.
http://angryanalyticsblog.azurewebsites.net/index.php/2016/05/16/api-strategies-with-power-bi/
Hello,
This didn't really answered my question but thank you for trying to help me.
Kind regards
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 10 | |
| 9 | |
| 8 | |
| 7 |