This topic contains 5 replies, has 2 voices, and was last updated by 
-
Posts
-
I found this Microsoft listing of supported data sources for SSAS 2012 (Tabular): https://msdn.microsoft.com/en-us/library/gg492165(v=sql.110).aspx
Microsoft Excel is supported as a data source via the “ACE 14 OLE DB” provider. On my computer the connection available and used is “ACE OLEDB 12”.
So, at this point connecting to Excel files in a tabular model doesn’t work.
My Google searches haven’t been fruitful, yet.
Does anyone have an idea where “ACE 14 OLE DB” can be downloaded from?
Ron,
Have you seen this link:
Thank you, Tom.
Looking through the post and searching around I found these two other posts helpful, too:
http://blog.codefluententities.com/2011/01/20/microsoft-access-database-engine-2010-redistributable/
http://blogs.msdn.com/b/farukcelik/archive/2010/06/04/accessing-excel-files-on-a-x64-machine.aspx
On Monday, I’ll see if they fix the issue.
Thanks again!
Ron,
Correct me if I am wrong, but I believe you are using SQL Server Data Tools. If I believe correctly, have you seen Avi Singh’s video on how to import an Excel Power Pivot model directly into SSAS Tabular? If not, you could follow this link:
http://www.powerpivotpro.com/2015/02/power-pivot-to-ssas-tabular-in-less-than-30-minutes/
Hey,
I solved the issue about Excel as a data source. A Microsoft post indicated our Windows Server instance needed an update, that I found at https://www.microsoft.com/en-us/download/details.aspx?id=13255
I had installed the update on my local machine. What was required was the update installed on the Windows Server machine with SSAS Tabular instance.
Works fine now!
Hopefully, this thread will help someone else encountering the same challenge.
Ron
Ron,
Glad to hear of your success.
Other forum visitors (including me) will definitely learn from your posts how to quickly resolve this issue.
The forum ‘Power Pivot’ is closed to new topics and replies.