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

แชร์
ฝัง
  • เผยแพร่เมื่อ 7 ก.ย. 2024
  • In this tutorial, you will learn how you can get JSON data from the Rest API call with the POST method.

ความคิดเห็น • 23

  • @phiqahful
    @phiqahful 2 ปีที่แล้ว +4

    This video saved my life. Thank you!

  • @ishanagrawal396
    @ishanagrawal396 15 ชั่วโมงที่ผ่านมา

    Great! How ro import data from GraphQL?

  • @joangarcia6415
    @joangarcia6415 2 ปีที่แล้ว +1

    Muchas gracias, me ha sido de gran ayuda !!

    • @bitsanalytics6949
      @bitsanalytics6949  2 ปีที่แล้ว

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

  • @LuisRamirez-xj9sj
    @LuisRamirez-xj9sj ปีที่แล้ว

    thanks to share!

  • @ask416
    @ask416 2 ปีที่แล้ว +3

    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}}

  • @DebaratiRay-di3xw
    @DebaratiRay-di3xw ปีที่แล้ว +2

    How to dynamically use body in the power query?

    • @joel5303
      @joel5303 5 หลายเดือนก่อน

      Did u find the solution for this

  • @user-ko6ly3ol5h
    @user-ko6ly3ol5h ปีที่แล้ว +1

    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

  • @yeravellisanthosh9296
    @yeravellisanthosh9296 ปีที่แล้ว +1

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

    • @deepakdange1267
      @deepakdange1267 ปีที่แล้ว

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

  • @nacional8
    @nacional8 2 ปีที่แล้ว +1

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

    • @bitsanalytics6949
      @bitsanalytics6949  2 ปีที่แล้ว

      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.

  • @FerwaTariq
    @FerwaTariq ปีที่แล้ว +1

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

    • @mranjank
      @mranjank ปีที่แล้ว

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

  • @alyssonsilva547
    @alyssonsilva547 2 ปีที่แล้ว +1

    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
      @bitsanalytics6949  2 ปีที่แล้ว

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

  • @user-yh4im3oe7b
    @user-yh4im3oe7b 5 หลายเดือนก่อน

    I need how to convert list of data.

  • @trevorshao
    @trevorshao 2 ปีที่แล้ว

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

  • @utpalkumar9602
    @utpalkumar9602 2 ปีที่แล้ว

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

  • @user-xt2vg2kl9i
    @user-xt2vg2kl9i ปีที่แล้ว +1

    how i get the data from post api to power bi