Showing results for 
Search instead for 
Did you mean: 
New Member

POST query with authorization token

Hi, I'm trying to post info into a DB using an endpoint, but It's not working, this is the query:





        data = Json.FromValue([ fieldName="someData"]),
        Source = Json.Document(Web.Contents("https://url", [Headers=[Authorization="authorization token", #"Content-Type"="application/json"], Content=data]))





If I remove the Content from the source, I'm able to get the whole record from the table, but as soon I add the content It show this error:





DataSource.Error: Web.Contents failed to get contents from 'https://myURL' (404): Not Found





Thanks in advanced.

New Member

Thanks @Daryl-Lynch-Bzy @but that is pretty much what we need to do: writing to a database.


I watch this video and that's what I'm trying to do. I have tried with a free API and works fine.


Thanks @ojosdegatonegro - I think you need to change this step:

 data = Text.FromBinary( Json.FromValue( [fieldName="someData"] ) )

I tried without Text.FromBinary, just Json.FromValue and the error remains

Sorry - I sure how to help.  Can you double check that Json is properly formatted by using VS Code or Postman.  Obtain the Json from the Text.FromBinary step and past it into another tool to see if the error is occurring.

This is the code using JsonPlaceHolder API:

    data = Json.FromValue([title = "ID_WERTPAPIER", body = "851399", userId = "US" ]),
    outputdata = Text.FromBinary(data),
    Source = Json.Document(Web.Contents("", [Headers=[#"Content-Type"="application/json"], Content=data]))

And it works!!! But if I use my own API, adding authorization to the header, something goes wrong, now the error message is this:


Expression.Error: We cannot convert a value of type Binary to type Text.


I know that my endpoint is working cause it works in postman.

Super User
Super User

Hi @ojosdegatonegro - what you mean by "post info into a DB"?  You should not use Power Query to write data into a database.  It is not recommended because Power Query could send the transactions multiple times to the database.


You also mention that API works without the Content.  This suggests that the API call is GET type.  It is not sual for url string to work as GET call and POST call - it is normally one or the other.  Can you provide more details on the API.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors