Forum Discussion

visure's avatar
visure
Regular Visitor
9 years ago
Solved

REST API Silent Authentication (Token)

Hi guys,   I was following the steps in this topic: Http://community.powerbi.com/t5/Developer/How-to-use-Power-BI-Rest-API-without-GUI-authentication-redirect/m-p/6030/highlight/true#   To perfo...
Need Help
  • visure's avatar
    visure
    9 years ago

    Thanks Eric_Zhang, I already solved it,

     

    Just read a little more how the authentication flow works :)

  • visure's avatar
    visure
    9 years ago

    Eric_Zhang

     

    Of course,

     

    When I calmly read the message "The user or administrator has not consented to use the application" I started to ask myself "where could I consent the permissions", the quick response came "Azure AD".

     

    I started to search how the Azure AD permissions system works and I found this link:
    Https://docs.microsoft.com/en-us/azure/active-directory/develop/active-directory-integrating-applications

     

    After reading it I conclude: I created the application through PowerBI (http://dev.powerbi.com/apps) which generated an application in Azure AD (http://portal.azure.com), so I still had to delegate the application permissions - my user was also the account administrator so I just needed to grant the permissions.

     

    Steps: 

    Create app on PowerBI > Go to Azure Portal > Find Azure Active Directory > Find the Application > Grant Permissions

     

    Any questions are welcome.

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago
visure wrote:

Thanks Eric_Zhang, I already solved it,

 

Just read a little more how the authentication flow works :)

visure

Could you share the solution?

visure's avatar
visure
Regular Visitor
9 years ago

Eric_Zhang

 

Of course,

 

When I calmly read the message "The user or administrator has not consented to use the application" I started to ask myself "where could I consent the permissions", the quick response came "Azure AD".

 

I started to search how the Azure AD permissions system works and I found this link:
Https://docs.microsoft.com/en-us/azure/active-directory/develop/active-directory-integrating-applications

 

After reading it I conclude: I created the application through PowerBI (http://dev.powerbi.com/apps) which generated an application in Azure AD (http://portal.azure.com), so I still had to delegate the application permissions - my user was also the account administrator so I just needed to grant the permissions.

 

Steps: 

Create app on PowerBI > Go to Azure Portal > Find Azure Active Directory > Find the Application > Grant Permissions

 

Any questions are welcome.

  • Valtyr's avatar
    Valtyr
    Advocate I
    9 years ago

    Thanks, that did the trick for me. 

  • dharamgoyal's avatar
    dharamgoyal
    Frequent Visitor
    8 years ago

    Hi visure,

     

    Doing same but still getting error:

    AADSTS65001: The user or administrator has not consented to use the application with ID 'xxxxxxxxxxxxxxxxxx' named 'LSNTestAPP'. Send an interactive authorization request for this user and resource.\r\nTrace ID: 19f4be86-94db-45ad-961a-46a570ad4300\r\nCorrelation ID: 99c5058f-177a-459b-9509-def5865d5fcf\r\nTimestamp: 2017-12-22 06:43:15Z

     

    It's error coming while login with power bi user credentials but when use azure port admin credentials then it's work so please let me know what i am missing to authenticate powerbi user to get access token.

     

    I have spend lot of time on it please help me out to resove this isssue.

    I hope for your quick response!

  • Ludia's avatar
    Ludia
    Helper I
    8 years ago

    Hello Visure,

     

    Steps: 

    Create app on PowerBI > Go to Azure Portal > Find Azure Active Directory > Find the Application > Grant Permissions

     

    Thanks a lot for your sharing and based on your steps, i couldn't find the Application before granting permissions? Could you kindly show the steps for "Create app on Power BI"?

     

    Many thanks

    Ludia

      • Ludia's avatar
        Ludia
        Helper I
        8 years ago

        visure

        Thanks a lot for your great help, my problem was solved

  • human239874's avatar
    human239874
    Frequent Visitor
    8 years ago

    Your clear and concise instructions really helped me out. I would have never figured out I had to go into portal.azure.com to enable the PowerBI permissions. I was thinking that Power BI was completely separate. Thanks a bunch for taking the time to post your solution!