Power Pivot with ODC connexion RRS feed

  • Question

  • Hi there!

    Recently, one of my user started using Power Pivot.

    He is trying to make a cube with ODC connections files.

    Sadly, we are having an error when trying to importe the data.

    Everything works, we test the connections inside power pivot with the test button, it works. But when we press finish and it start importing, we get an error. 

    "The current operation was cancelled because another operation in the transaction failed."

    And here is my connection string :

    Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sql1tex;Initial Catalog=CommandeVente;Data Source=mure;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=ADS2227;Use Encryption for Data=False;Tag with column collation when possible=False;Password=**********

    Thank you!

    Friday, April 22, 2016 3:51 AM


All replies