Forum Discussion

seijim's avatar
seijim
Icon for Microsoft Employee rankMicrosoft Employee
11 years ago
Solved

How to use Power BI Rest API without GUI authentication (redirect uri)

I'm developing an Azure worker role application which pushes data to PowerBI.com service. I referred a C# sample client application via Git Hub. But it authenticates using GUI (redirect uri) during ...
aevers's avatar
aevers
Icon for Advocate I rankAdvocate I
11 years ago

I did this by using the refresh token provided by the GUI authentication process and only using the AcquireTokenByRefreshToken method in my worker with the this token. I now just have to refresh the RefreshToken after a few days and update the configuration of my cloud worker (stored in redis -> worker checks for updated token). I do not re-use the Refresh Token in the configuration for every authentication request though but the new ones provided by AcquireTokenByRefreshToken.

  • seijim's avatar
    seijim
    Icon for Microsoft Employee rankMicrosoft Employee
    11 years ago

    Thanks for your suggestion.

    I will try it.

    • salesavlino's avatar
      salesavlino
      New Member
      10 years ago

      Did the suggestion provided by him worked for you. Because i feel the suggestion provided is not relavant to the one you asked. He mentioned as  "using the refresh token provided by the GUI authentication process" but as per my understanding its not the question you asked. I guess asked not to redirect to the loginpage, instead it should authenticate silent through code and get the "code" parameter in turn.

      • seijim's avatar
        seijim
        Icon for Microsoft Employee rankMicrosoft Employee
        10 years ago

        Thanks for your message.

        Actually his answer doesn't completely adapt to my requirement in the point of GUI less.

        But that's an useful workaroound. 

         

        Azure Stream Analytics (ASA) also requires Web GUI authentication on management portal when we select Power BI output.

        I've been thinking that his workaround is an only solution because ASA behaves so. 

         

        Do you know how to implement silent authentication ?

         

        Regards,

        -seiji

         

  • markive's avatar
    markive
    Icon for Advocate II rankAdvocate II
    10 years ago

    aevers what you say makes sense, but how do you refresh the token after a few days? Have you automated this?

     

    My app doesn't use Active Directory so I will want a single account setup and to silently authenticate to display the report to a certain set of users.

     

    I was thinking that the Active Directory REST api might be another option, but I've not used it before and just reading into it.