Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
thanks and I looked at the files and i have followed the simiar steps with respect to import modules - preparing auth with variables- connecting to PBI service acc..
I see no difference in my code,unfortunately,i am still having same '401 unauthorized' error
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.