Forum Discussion
Datasets - Execute Queries end point from within ADF
Hi community, I do have the following issue: I do try to tap this end point https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/executeQueries from ADF pipline but I get an error: Failur...
Hi lupa0682
I have not tried it with ADF, but with the error 403 it does indicate that there is an authentication error as far as I can see.
Can you also make sure that this is enabled in your Power BI Admin Tenant settings as shown below.
An update:
It does work now... In my REST linked service for https://api.powerbi.com/, I changed Authentication type from 'service principal' to 'Anonymous'.
I do have a web activity to get a BearerToken, where I POST AD app credentials in request body to https://login.microsoftonline.com/********************.onmicrosoft.com/oauth2/token
REQUEST BODY:
@concat('grant_type=client_credentials&client_id=',activity('GetAppClientID').output.value,'&resource=https://analysis.windows.net/powerbi/api','&client_secret=',activity('GetAppSecret').output.value)Therefore, REST linked service is just pointing at generic, base URL (https://api.powerbi.com/) and it doesn't require any form of authentication.I hope that makes sense.Thanks for all your help,Wojciech
