Data-driven subscription cannot be created because the report or shared dataset has user profile dependencies and cannot be run unattended.
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()
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.