Having tried numerous times I am still coming up against the following errors when connecting to a PowerPivot dataset via an Excel 2010 64-bit file:
It appears that you don't have Tableau PowerPivot Add-In (Excel Add-In) installed. Please install Tableau PowerPivot Add-In and try again.
Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.
The PowerPivot dataset exists in the xlsx and I have added a PowerPivot PivotTable to a worksheet in order to ensure the connection is available.
Anybody have any ideas, workarounds, etc?