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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
bender1234
New Member

Passing Cookie in Header fails when querying GraphQL backend with GraphQL variables

Hi

 

I have a JWT token and need to pass it along with my POST request to a REST endpoint like so: 

 

 

 

 

let
	url = "https://test.my-website.com/graphql",
	token = "express:sess=ey....",

    Source = Web.Contents(
	url,
	[
		Headers=[
			#"Method"="POST",
			#"Content-Type"="application/json",
			#"Cookie"=token,
		],
		Content=Text.ToBinary("{""query"": ""{  allData( $filter: [FilterInput]){  allData(filter: $filter) {
					  field1
					  field2
					  } }""}")
	]
    ),

    #"JSON" = Json.Document(Source)
in
    JSON

 

 

 

 

If I run the same in Postman and pass the token in the header with "Cookie" as name of the header entry and "express:sess=ey...." as the value, it works all fine.

When I do the same in the advanced editor of a "Blank Query" data source, I get "Expression.Error: Access to the resource is forbidden."

Looking at the Query diagnostics, the server returned: Message: The remote server returned an error: (403) Forbidden.

I followed this tutorial to send a GraphQL query: https://www.linkedin.com/pulse/connect-powerbi-graphql-endpoint-amir-khan/ 

 

How does Power Bi blank query works differently compared to Postman? Is it using a different encoding or something?

 

Any help is much appreciated.

 

Thanks

 

 

1 ACCEPTED SOLUTION
bender1234
New Member

Thanks Gao,

 

I managed to solve my problem and it had nothing to do with the authentication. Using a cookie like the example below works just fine.
The actual problem was the graphql part which had incorrect formatting. I was mislead by the error message.

If anyone wants to send a graphql request from power bi with actual variables, this is how it worked for me:

let
	url = "https://my-website.com/graphql",
	token = "express:sess=ey... [replace this value with you Cookie ]",
	body = "{ ""query"": ""query allParameter($filter: [FilterInput]) { allParameter(filter: $filter) { parameterId } }"", ""variables"": {""filter"": []} }",
    response = Web.Contents(
	url,
	[
		Headers=[
			#"Method"="POST",
			#"Content-Type" = "application/json",
			#"Cookie"=token
		],
		Content=Text.ToBinary(body)
	]
    ),

    jsonResponse = Json.Document(response)
   
in
    jsonResponse

 

View solution in original post

2 REPLIES 2
bender1234
New Member

Thanks Gao,

 

I managed to solve my problem and it had nothing to do with the authentication. Using a cookie like the example below works just fine.
The actual problem was the graphql part which had incorrect formatting. I was mislead by the error message.

If anyone wants to send a graphql request from power bi with actual variables, this is how it worked for me:

let
	url = "https://my-website.com/graphql",
	token = "express:sess=ey... [replace this value with you Cookie ]",
	body = "{ ""query"": ""query allParameter($filter: [FilterInput]) { allParameter(filter: $filter) { parameterId } }"", ""variables"": {""filter"": []} }",
    response = Web.Contents(
	url,
	[
		Headers=[
			#"Method"="POST",
			#"Content-Type" = "application/json",
			#"Cookie"=token
		],
		Content=Text.ToBinary(body)
	]
    ),

    jsonResponse = Json.Document(response)
   
in
    jsonResponse

 

v-cgao-msft
Community Support
Community Support

Hi @bender1234 ,

Ensure Correct Token Format: Double-check the format of your JWT token. Ensure it's correctly formatted and includes the necessary prefix (usually "Bearer") if required by your endpoint. For JWT tokens, the header is typically passed as an "Authorization" header rather than a "Cookie".

Use Authorization Header: If your endpoint expects a JWT token for authentication, it's more common to use the "Authorization" header instead of "Cookie". Here's an adjusted example:

let
  url = "https://test.my-website.com/graphql", 
  token = "Bearer ey....", 
  Source = Web.Contents(
    url, 
    [
      Headers = [#"Method" = "POST", #"Content-Type" = "application/json", #"Authorization" = token], 
      Content = Text.ToBinary(
        "{""query"": ""{  allData( $filter: [FilterInput]){  allData(filter: $filter) {
                      field1
                      field2
                      } }""}"
      )
    ]
  ), 
  JSON = Json.Document(Source)
in
  JSON

 

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors