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

Поделиться
HTML-код
  • Опубликовано: 30 июл 2021
  • In this tutorial, you will learn how you can get JSON data from the Rest API call with the POST method.

Комментарии • 22

  • @phiqahful
    @phiqahful 2 года назад +4

    This video saved my life. Thank you!

  • @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..😀

  • @ask416
    @ask416 Год назад +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}}

  • @LuisRamirez-xj9sj
    @LuisRamirez-xj9sj Год назад

    thanks to share!

  • @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

  • @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 ?

  • @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.

  • @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.

  • @DebaratiRay-di3xw
    @DebaratiRay-di3xw Год назад +2

    How to dynamically use body in the power query?

    • @joel5303
      @joel5303 4 месяца назад

      Did u find the solution for this

  • @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.

  • @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

  • @user-yh4im3oe7b
    @user-yh4im3oe7b 4 месяца назад

    I need how to convert list of data.

  • @user-xt2vg2kl9i
    @user-xt2vg2kl9i Год назад +1

    how i get the data from post api to power bi