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

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