My questions is : how should I config SSRS subscription a report, which consumes SSAS datasource. I already googled and lookup stackoverflow a lot and still couldn't make it work.

Problems: I developed and deployed a SSRS report to the server, and next I need to make subscription for that report to send emails.

And the report is using SSAS as datasource. I learnt that SSAS required to use windows credentials and I already setup the datasource . Datasource tested However, when I attempted to click [New subscription], it alerts: enter image description here

3 Answers 3


I have blogged about this exact issue. The workaround/solution involves expression-based connection strings which can be a bit painful. But I have prototyped a tool to automate the setup of those connection strings after deployment:

Using EffectiveUserName To Impersonate in SSAS


Here is my steps to resolve the problem by following GregGalloway's blog.

1 create a parameter called username, and give it a default user name.enter image description hereenter image description here

2 Edit the datasource and click [Fx] to create a expression as the connection string.enter image description here

  1. Key in the following as the value of [Fx], please note that Parameters!username.Value which [username] is the parameter name created in #1

    ="Data Source=[your ssas server ip];Initial Catalog=[your ssas catalog name];EffectiveUserName=" & Parameters!username.Value

  2. Deploy the report.

  3. Open the report on the server on the drop down menu click [Manage], then open data source, -turn on [credentials stored securely.....] -key in [user name] , [Password], -Turn on [Use as Windows credentials when connecting to the datasource. enter image description here

    enter image description here

    1. Finally create subscription

    List item


in the report it self, inside "data source" use SQL credential :

enter image description here

  • How would SQL authentication work with SSAS?
    – Tom V
    Commented Mar 30, 2016 at 6:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.