SPN with Analysis Services

[acbg]

I have embedded reports which uses SPN to connect to Power BI.

It works when the power bi report is imported / data stored in service. 

But when the data is stored in Analysis Service I am either getting Forbidden or Bad Request.

Getting Bad Reqeuest when UserName is not passed through and Forbidden when UserName is passed through. I don't need username to be passed through since this is using SPN to access the report and CustomData for RLS.

Both Imported Data report and AS Report are in the same workspace, which makes me think the issue is with AS access.

I have given Server Admin Access via SSMS, added the SPN to the security roles within the database and also given Owner access using Azure portal. 

Is anyone seeing anything wrong with the way the SPN is setup in AS or anything else I need to do for embed report to work?

[acbg · Accepted solution]

Was able to finally figure this one out.

Username being passed through had to be Object ID of the SPN when the power bi report is connected to AS.

You can get the Object ID in Azure portal by just looking up the SPN:

Thanks to the link here:

https://github.com/MicrosoftDocs/powerbi-docs/issues/910