Forum Discussion

dparkinson's avatar
dparkinson
Advocate I
10 years ago

Authentication Pain - adal-node

Hi,

 

I'm trying to authenticate with Azure AD to access the Power BI APIs, but having some trouble.

 

I'm using adal-node to write a console app that uses the server to server via client credentials example outlined here.

 

Unfortunately I can't seem to get access.

 

If I use https://login.windows.net/common/oauth2/authorize as the authority URI (as per the powerbi doc), I get a 404 which seems odd.  If I use the authority URI as per the example for adal-node, I appear to get a token.  On using that token to access api.powerbi.com though, I get a 403 error.

 

If anyone is able to shed some light on this, that would be great.

 

Many thanks,

D.

 

 

3 Replies

Replies have been turned off for this discussion
  • This stackoverflow thread will probably help. Power BI needs user to be involved in authentication. The 403 is 'forbidden' so url is found but permissions not granted.

  • alexsilvar's avatar
    alexsilvar
    Frequent Visitor

    You should use the authorityHostUrl like this:

     

     

    var authorityHostUrl = 'https://login.microsoftonline.com/';
    var tenant = 'yourtenant.com';
    var uri = authorityHostUrl + '/' + tenant;
    ...
    var context = new adal.AuthenticationContext(uri);//Start adal context

    ([G]old)

     

    • duncfair's avatar
      duncfair
      Helper IV

      Could you please elaborate on this? I am frustrated with the lack of granularity of the refresh process and would like to kick off a dataset refresh via powershell after I complete a number of ETL processes.