topic Re: Authentication Pain - adal-node in Developer

Authentication Pain - adal-node

dparkinson — Thu, 03 Mar 2016 14:09:42 GMT

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,

Re: Authentication Pain - adal-node

curtisp — Sat, 21 May 2016 20:06:20 GMT

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.

Re: Authentication Pain - adal-node

alexsilvar — Thu, 19 Apr 2018 14:02:08 GMT

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)

Re: Authentication Pain - adal-node

duncfair — Thu, 19 Apr 2018 16:09:49 GMT

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.