Data could not be retrieved from the external data source

Question

Data could not be retrieved from the external data source

tt-615680

SSCertifiable

Points: 7835
More actions
December 13, 2011 at 4:30 am

#247602

Hi All,
I'm trying to retrieve data from excel be connectiong through Analysis Services and I keep getting the following error message:
Data could not be retrieved from the external data source. Error message returned by external data source:
The "DATABASE NAME" cube either does not exist or has not been processed.
Would anyone let me know what I need to do to get back the Cube please.
Thank you in advance.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 1

Are you trying to connect to SSAS from an Excel sheet, or are you trying to connect from SSAS to an Excel file?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

tt-615680 SSCertifiable Points: 7835 More actions · Answer 2

Koen Verbeeck (12/16/2011)
Are you trying to connect to SSAS from an Excel sheet, or are you trying to connect from SSAS to an Excel file?

Thank you for your response!

I'm trying to connect from SSAS to an Excel file.

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 3

tt-615680 (12/21/2011)
Koen Verbeeck (12/16/2011)
Are you trying to connect to SSAS from an Excel sheet, or are you trying to connect from SSAS to an Excel file?
Thank you for your response!
I'm trying to connect from SSAS to an Excel file.

That is not possible I think.

You can connect inside an Excel file to an SSAS cube though.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

arun1_m1 SSCommitted Points: 1949 More actions · Answer 4

Hi ,

As I understand from your query , you want to create a SSAS cube from the excel data. If I am correct then the below link should help you with the information.

[http://office.microsoft.com/en-us/excel-help/creating-data-cubes-using-excel-and-text-files-HA001012712.aspx]

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 5

arun1_m1 (12/21/2011)
Hi ,
As I understand from your query , you want to create a SSAS cube from the excel data. If I am correct then the below link should help you with the information.
[http://office.microsoft.com/en-us/excel-help/creating-data-cubes-using-excel-and-text-files-HA001012712.aspx]

I tried it, but I don't get the option to launch the OLAP wizard.

It is quite an old version they are speaking of 🙂

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP