Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi Power BI Community
I am struggling with calling an API in Power Query. I am not good at the framework of how I would call an API that requires a static bearer token along with a body and headers. I called it successfully in POSTMAN but need help with the code in Power Query.
Please see my code below which I have changed the token and other elements for data security:
Thanking you very much in advance.
let
url = "https://sb2.replicon.com/ATP/services/ReportService1.svc/GenerateReport",
body = "reportUri"= "urn:replicon-tenant:af0682a50:report:4ca3-93bf-5b0f5dc07dc7",
filterValues = [],
outputFormatUri = "urn:replicon:report-output-format-option:csv",
Source = Json.Document(Web.Contents(url,[Content=Text.ToBinary(body),
Headers=
[#"Content-Type"="application/json"]
[#"X-Replicon-Application"]="companykey-leaveatp"]
[#"Authorization"] = "Bearer IzJ6ZGW1ZDA2ZDMDk"
]))
in
Source
Hi @rush ,
Pls refer the following article ,and check if it is helpful:
Solved: API call with form params in power query - Microsoft Power BI Community
Solved: Creating Loop in Power Query and API - Microsoft Power BI Community
Best Regards
Lucien
@v-luwang-msft Thanks but I am not winning with that info.
I adjusted the query which is giving me an invalid identifier error:
let
url = "https://sb2.replicon.com/ATP/services/ReportService1.svc/GenerateReport",
body = "reportUri"= "urn:replicon-tenant:503a24bcd3809:report:d6b-b33c-4ca3-93bf-5dc7",
filterValues = [],
outputFormatUri = "urn:replicon:report-output-format-option:csv",
Source = Json.Document(Web.Contents(url,[Content=Text.ToBinary(body),
Parsed_JSON = Json.Document(body),
BuildQueryString = Uri.BuildQueryString(Parsed_JSON),
Source = Json.Document(Web.Contents(url,
[Headers =
[#"Content-Type"="application/json"],
[#"X-Replicon-Application"="companykey-leavebalance"],
[#"Authorization" = "Bearer llOThhZGE1ZDDA2ZDM4MDk"],
Content = Text.ToBinary(BuildQueryString)] ))
in
Source
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
81 | |
67 | |
62 | |
46 | |
45 |