Forum Discussion

Peter_Jeyaraj_I's avatar
Peter_Jeyaraj_I
Helper II
4 years ago

PowerBI Connection to Synergi life API

Hi,  My API connection works well in Postman, but i was not able to establish/authenticate the connection in PowerBI.  I tried, Web option and Advance editor. Anyhow, i am new to the API side, so n...
Need Help
Peter_Jeyaraj_I's avatar
Peter_Jeyaraj_I
Helper II
4 years ago

Hi v-henryk-mstf ,

 

Added the permission via Portal.azure.com. anyhow, still getting the same error msg. 

Getting below msg, when i try to get data via PowerBI. 

 First time exploring this API, so not sure whether i am following the right steps. If possible, could you please share the step by step process for API authentication in PowerBI.. It would be great help for me. 

Peter_Jeyaraj_I's avatar
Peter_Jeyaraj_I
Helper II
4 years ago

It works now by using the token number generated from postman. hope I can able to proceed further. will come back if i stuck again

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    Hi Peter_Jeyaraj_I ,

     

    Thank you very much for your feedback. If the advice I provided was helpful to you, you can mark it as the correct solution to help the other members find it more quickly.


    Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Peter_Jeyaraj_I's avatar
      Peter_Jeyaraj_I
      Helper II
      4 years ago

      Hi v-henryk-mstf , 

      Moved to the 2nd step, but still i am getting the below erros while generating the token number. 

      M-Query

      let
      // Basic auth
      authKey = "Basic ****************************",
      url = "https://api-e2e.danfoss.com/oauth2/token",
      // bearer token
      GetJson = Web.Contents(url,
      [
      Headers = [#"Authorization"=authKey,
      #"Content-Type"="application/x-www-form-urlencoded;charset=UTF-8"],
      Content = Text.ToBinary("grant_type=client_credentials")
      ]
      )
      in
      GetJson

       

      Error msg

       

       

      See the working http from postman

       

      thanks in advance for your support