SSRS data driven subscription do not work if we have user profile dependencies

Error:

Data-driven subscription cannot be created because the report or shared dataset has user profile dependencies and cannot be run unattended.

Fix:

When we tried to setup data driven subscriptions we kept getting error: report or shared dataset has user profile dependencies and cannot be run unattended.

SSRS data driven subscription do not work if we have user-id as parameter.

We deleted the user-id parameter and Viola! the data driven subscription started working.

You will need a “method” to get rid of the UserID.

Public Function UserName()
Try
Return Report.User!UserID
Catch
Return "System"
End Try
End Function

You must use stored credentials if you want to use a scheduled report:

Stored credentials are required if you want to support subscriptions, or schedule report history generation or report snapshot refreshes.

http://msdn2.microsoft.com/en-us/library/ms160330.aspx

Sources:

SSRS data driven subscription dont work if we have user-id as parameter

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/cb4e7816-d421-4921-a4e5-b258888748f9/user-profile-dependencies-problem-in-report-scheduling?forum=sqlreportingservices