Lesson 16 How to load REST API post call data into Power BI Desktop. Do subscribe…!!!

In this tutorial, you will learn how you can get JSON data from the Rest API call with the POST method.

[@phiqahful]

This video saved my life. Thank you!

[@bitsanalytics6949]

Stay tuned for new videos.

[@joangarcia6415]

Muchas gracias, me ha sido de gran ayuda !!

[@bitsanalytics6949]

Es bueno saber que te ayudó. Ese es mi objetivo para compartir gracias..😀

[@LuisRamirez-xj9sj]

thanks to share!

[@ask416]

I've the following headers in the Post method, I'm getting the output in Postman, but unable to pass it in Power BI. Authorization = Basic {{oauth_authorization}} signature = {{oauth_signature}} timestamp = {{oauth_timestamp}}

[@ishanagrawal396]

Great! How ro import data from GraphQL?

[@user-ko6ly3ol5h]

Comes up with: DataFormat.Error: We found extra characters at the end of the JSON input. Details: Value=< Position=4 Please advise fix for this

[@DebaratiRay-di3xw]

How to dynamically use body in the power query?

[@joel5303]

Did u find the solution for this

[@yeravellisanthosh9296]

How to dynamically ( users selected data in slicer need to send in the body) send in the body of post request ?

[@deepakdange1267]

Did you find any answer for this question as I am also searching for the same.

[@FerwaTariq]

Hey, I have a bearer token for authorization in my post request. How can I make it work in that case?

[@mranjank]

#"Authorization"=AuthKey , AuthKey is a variable with the actual token

[@alyssonsilva547]

Hi, I need connect power bi in api, i have any information header("Authorization", "Basic) + user and password body("select * from....'") How can I do it?

[@bitsanalytics6949]

There are multiple videos here on this channel please chek out.

[@nacional8]

Hello, anyone know what the end point is if you are trying to use the rest point of power bi?

[@bitsanalytics6949]

End point is your rest api URL. It depends on how you are calling the methods get or post. Power BI allows non dynamic rest api calls both get n post. You can only configure static parameters.There certain methods can be used in M language while connecting to endpoint. There are my previous videos on this topic it may watching worth.

[@kamalesank-w5o]

I need how to convert list of data.

[@trevorshao]

hi the body how can I write response_type=JSON? Content=Text.ToBinary("{""response_type""=""XML""}") is this correct?

[@utpalkumar9602]

I need to pass basic Authorization also which nothing but "username" and "Password" How can I archive this one ?

[@user-xt2vg2kl9i]

how i get the data from post api to power bi

[@bitsanalytics6949]

Check my other videos