This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.