Hi all
Just started MSBI ,very new
I am trying to connect to excel source..But its shows an error any idea ? or suggestion ?
Did you configure an 'Excel Connection Manager'? It looks as if it's prompting you to set one up.
sorry, configuring excel ?
i installed odbc drivers .i will try to check in google configuring excel manager
same error ,please suggest how to resolve
please help
A similar usecase is covered in this sql server solution page. If you are still having a trouble, you should try the following driver . You will be able to find the relevant documentation at the bottom of this page.
please post a screen shot of your excel spreadsheet ?