Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
georgy_gryaznov
Frequent Visitor

How to extract http-response header?

Hi

 

How to extract http-response "set-cookies" header?
How to use WebMethod.Get?

 

3 REPLIES 3
jgarcia_new
Frequent Visitor

Where can I find more information about this to make a simple example in my power bi query, since I can't replicate your example 😞

jgarcia_new
Frequent Visitor

how did you manage to solve this? I am trying to obtain the cookies from a query to the server, cookies that will later serve me to make a request to the login

Aron_Moore
Solution Specialist
Solution Specialist

I've done similar work using the R data connection and httr library.

 

A sample of my code:

let
    bodyString = "'{""user_name"":"""&Text.From(UserName)&""",""password"":"""&Text.From(Password)&"""}'",
    Source = R.Execute("library(httr)#(lf)library(jsonlite)#(lf)getToken <- POST(""https://endpoint.com/api/v1/login"", add_headers(""Content-Type""=""application/json""), body = "&bodyString&")#(lf)tokenIs <- cookies(getToken)#(lf)getData <- GET(""https://endpoint.com/api/v1/sr?type=request&insert_time=1483257600000,0"", add_headers(""Content-Type""=""application/json""), set_cookies(""name""=tokenIs$name,""value""=tokenIs$value))#(lf)result <- data.frame(content(getData, ""text""))"),
    result1 = Table.ToRecords(Source{[Name="result"]}[Value]),
    #"Converted to Table" = Table.FromList(result1, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    Column1 = #"Converted to Table"{0}[Column1],
    stuff = Json.Document(Column1[#"content.getData...text.."]),
    #"Converted to Table1" = Table.FromList(stuff, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn.....

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.