Question

Three peaks on Thu, 10 Aug 2017 14:04:36


Hello,

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.

Steve


Sponsored



Replies

Olaf Helper on Sat, 19 Aug 2017 04:47:00


Hello Steve,

After you added a new datasource in Excel it should be available from "Existing Datasource".