Service principal raising 401 error - access PBI dataset- DAX query

[Anonymous]

Hi,

I am trying to use "REST api support for DAX" feature relased by MSFT in aug for public preview.

https://powerbi.microsoft.com/en-us/blog/announcing-the-public-preview-of-power-bi-rest-api-support-...

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.

https://docs.microsoft.com/en-us/azure/active-directory/develop/howto-create-service-principal-porta...

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.

[Anonymous]

Hi @Anonymous,

As the blog said, this feature is just public preview and it is not released to the stable version. So I think some of the processes may not be up to date. In addition, the blogger also mentions they are working on the document update.

Maybe you can try to contact the power bi team to confirm if any additional settings are required for this new feature.

Regards,

Xiaoxin Sheng

[Anonymous]

Thanks .I will contact MSFT with a ticket and see what is wrong.