Three peaks on Thu, 10 Aug 2017 14:04:36
Having created a suite of cubes for end users I've been challenged to make a more industrial way to publish them.
Attaching to a data source via the 'Data' tab in excel and then using either 'From Other Sources' , 'From Analysis Services;' and completing the wizard is deemed insufficient.
Is there a way to list a set of data sources from a library of sorts and have them open in excel?
I recognize I can create excel workbook templates already connected to the data source but prefer not to go that route.
Thanks in advance.
Olaf Helper on Sat, 19 Aug 2017 04:47:00
After you added a new datasource in Excel it should be available from "Existing Datasource".