Passing Cookie using Web.Contents in PowerBI Desktop

[adarshmadrecha]

I have API which authenticates user based on Cookies (PHP Sessions)

I am using below code to pass cookies

= Json.Document(Web.Contents("https://myapp.example.com/api/test.php", [Headers=[Cookie="PHPSESSID:123abc"]]))

But the above code does not work.

Can you please help in finding out what I am doing wrong?

[adarshmadrecha · Accepted solution]

I understood waht the issue was.

Instead of using : I sould use = to scecify cokie name and value.

= Json.Document(Web.Contents("https://myapp.example.com/api/test.php", [Headers=[Cookie="PHPSESSID=123abc"]]))

[jgarcia_new]

Good morning. How did you manage to get the cookie from power bi? I am currently making a request to obtain the cookie, said cookie comes in the headers of the server response.

Thank you !

[v-chuncz-msft]

@adarshmadrecha,

You may take a look at link below.

http://www.excelandpowerbi.com/?p=58