Forum Discussion
SPN to query PBI dataset using REST api calls
Hi,
I am trying to use "REST api support for DAX" feature relased by MSFT in aug for public preview.
I have been able to query dataset and retreive the result using my creds but the issue is i am not able to succeed with SPN.I have set up SPN the way it has been described in the MSFT document below to allow rest api calls with DAX but i am unable to understand what is blocking the SPN.
I receive "401 unauthorized error " with SPN.
My steps:
-created AAD app and SPN
-created AAD security group and added the SPN as member into it
-provided SPN and security group 'admin' access on the PBI workspace
-provided 'dataset.readwrite.all' permission for the app
-added the SPN to allow REST api calls on tenant settings
-workspace upgraded to v2
Am i mising something ? Also,is it required for me the provide the app with tenant.read.all permission? I dont see this as requirement in msft docs but i did see this in some other online discussions.
2 Replies
Hey Anonymous ,
here on my github repo you will find some examples on how to create a SPN and use this in combination with the Power BI Admin Scanner REST APIs. There is a presentation and some PowerShell scripts that you might find useful.
Hopefully, this helps to tackle your challenge, if not please share your code, otherwise it's difficult provide more guidance: https://github.com/tomatminceddata/thehive
Regards,
Tom
