Problem with Power BI Report Server Email Subscriptions

[bjarvis]

Hi,

https://support.microsoft.com/en-gb/help/842423/a-call-to-the-authzinitializecontextfromsid-api-func...

The bug above that was fixed in SSRS 2016 SP1 still seems to be present in Power BI Report Server so when sending email subscriptions with an embedded or attached report I get the following errors logged:

library!WindowsService_1!1220!08/17/2017-11:10:27:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.WindowsAuthz5ApiException: , Microsoft.ReportingServices.Diagnostics.Utilities.WindowsAuthz5ApiException: Windows returned a ERROR_ACCESS_DENIED error when Reporting Services attempted to call the Windows Authz APIs. If this issue persists the Reporting Services account may not possess permission to perform authentication checks. Check the Windows Authz documentation for more information and details on diagnosing issues. Authz method: AuthzInitializeContextFromSid, Error code: 5, UserName: ;

emailextension!WindowsService_1!1220!08/17/2017-11:10:27:: e ERROR: Error sending email. Exception: Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The permissions granted to user '' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation.. Additional Information:

The fix described in the article resolves the issue so it seems like the fix made in 2016 SP1 hasn't been merged in.

Thanks.

[v-qiuyu-msft]

Hi @bjarvis,

From the error message, the service account lacks permission. Please open the Report Server Configuration Manager -> Service account, change the service account to use a domain account then test it again.

Best Regards,
QiuyunYu

[bjarvis]

Hi @v-qiuyu-msft,

The service account was already set up as a domain account that has the correct permissions in active directory.

Thanks,

Ben