Need to connect PowerPivot to SSAS using HTPP access. The Table Import Wizard gives the error below when Importing data to PowerPivot (just from the client machine, its works just fine for me!).
An unexpected error occurred (file ‘pfoledbprops.cpp’, line 479, function ‘PFDBPropsOledb::MapPropertyToOledb’). A connection could not be made to the data source with the DataSourceID of ‘c68b8491-be1b-4c6a-a56f-7b2b2a53164b’, Name of ‘tet’. An error occurred while processing table ‘Query’. The current operation was cancelled because another operation in the transaction failed. Out of line object ‘DataSource’, referring to ID(s) ‘c68b8491-be1b-4c6a-a56f-7b2b2a53164b’, has been specified but has not been used. Out of line object ‘DataSourceView’, referring to ID(s) ‘Temp_DSV’, has been specified but has not been used.
Someone could help me please!!