I need to replace the datasource on my workbook from Excel to SSAS Cube. I got the below link "http://kb.tableausoftware.com/articles/knowledgebase/replacing-data-source" which explains how to get this done with datasources. But unfortunately, this approach is not working with SSAS.
Is there any way to replace Excel source with SSAS cube?
Unfortunately I don't believe it is possible to swap data sources between SSAS and SQL or Excel. You can definitely swap the connection between cubes on SSAS. Maybe one for the feature request?