1

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!!

Thanks.

Improve this question

1 Answer 1

Reset to default
0

A connection could not be made to the data source with the DataSourceID of ‘c68b8491-be1b-4c6a-a56f-7b2b2a53164b’, Name of ‘tet’.

This indicates that there's a possible login issue. Ensure that you have specified a domain account with proper permissions to the data source tet.

The same with pictures: https://gordoncluster.wordpress.com/2013/08/22/ssas-a-connection-could-not-be-made-to-the-data-source-with-the-datasourceid/

Improve this answer
3
  • Thanks for youre reply. I already specified a domain account for the data source, and i could connect from my machine. The problem is with the client machine! ps : the client uses the same account as me to test, but the wizard gives him the error message. Commented Oct 5, 2016 at 10:55
  • @soukaouta could you try to add SET NOCOUNT ON above the line starting with INSERT and see if that helps. Commented Oct 5, 2016 at 11:51
  • the SET NOCOUNT ON didn't resolve the problem Commented Oct 6, 2016 at 14:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.