I'm trying to connect Tableau to a PowerPivot model. I'm using Tableau 8 and have installed the PowerPivot plugin and drivers successfully. I'm trying to connect to a local excel file and I get the following error:
[Tableau PowerPivot AddIn] Unable to connect to the MS PowerPivot data source. Couldn't find valid MS PowerPivot data in the workbook you specified.
Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.
I have validated that there is date in the mode.
I stumbled into the same issue a minute ago, and chose to create a Pivot table in the Excel workbook from the PowerPivot model (i did not setup anything in the pivot table).
This solved my issue - can you please check, if it will work for you?