Error “The permissions granted to user 'User\User' are insufficient for performing this operation” while printing SSRS report to Excel
User will get error “The permissions granted to user XXX are insufficient for performing this operation” while printing SSRS report directly to Excel (only to Excel, PDF and all other formats will work ok) file. This is caused by missing browser permission to root folder. In case of Excel format, system checks if any content is available in SSRS, but he checks in root folder (what you see if you put Report Manager URL in browser) and not in Microsoft Dynamics AX report folder (as I would expect). Error in call stack is:
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Microsoft.Dynamics.AX.Framework.Reporting.Shared.ReportException: The permissions granted to user 'DOMAIN\USER' are insufficient for performing this operation.
at Microsoft.Dynamics.AX.Framework.Reporting.Shared.Proxy.FindItem(String itemPath) at Microsoft.Dynamics.AX.Framework.Reporting.Shared.Proxy.ItemExists(String itemPath) at Microsoft.Dynamics.AX.Framework.Reporting.Shared.Proxy.SupportXLSX(String serverUrl) at Microsoft.Dynamics.AX.Framework.Reporting.Shared.ReportManager.ReportFileFormatString(ReportFileFormat fileFormat, String postfix, String serverUrl) at Microsoft.Dynamics.AX.Framework.Reporting.Shared.ReportManager.RenderOnePage(Warning[]& warnings) at Microsoft.Dynamics.AX.Framework.Reporting.Shared.ReportManager.RenderReport(Warning[]& warnings, String executionID, Boolean overridePaperSettings) at Microsoft.Dynamics.AX.Framework.Reporting.Shared.Proxy.RenderReportToFile(String reportPath, ParameterValue[] parameters, String fileName, ReportFileFormat fileFormat, String deviceInfo, String execId) --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at Microsoft.Dynamics.AX.ManagedInterop.ClrBridgeImpl.InvokeClrInstanceMethod(ClrBridgeImpl* , ObjectWrapper* objectWrapper, Char* pszMethodName, Int32 argsLength, ObjectWrapper** arguments, Boolean* argsAreByRef, Boolean* isException)