none
PowerPivot fails when importing data using SAS OLE DB 9.4 Local Dataset provider

    Question

  • PowerPivot cannot import data using the "OLE DB provider v9.4" from SAS Instittute.
    Testing the connection in the wizard is ok, and the table list apear and chosing a "table" from the list is ok, but importing fails with a "An error occurred while processing table. OLE DB or ODBC error: The Local Provider does not currently support SQL processing.." error message.
    According to SAS documentation, that is correct. The Local Dataset does not support SQL Processing.

    But importing the same dataset into Excel using the same provider for but using Query Tables (Data tab) works just fine.
    Aparently there is a difference in how Query Tables and PowerPivot import works in Excel 2013/2010.
    Is there a way to get around this SQL Query dependancy in PowerPivot ?

    Thanks in advanced

    Stig

    PS, The last approach could be used as a workaround, with a Linked Table to PowerPivot, but I need to have the model published and refreshed in Sharepoint later.

    Friday, December 27, 2013 2:27 PM

Answers

  • Hi,

    Your question falls into the paid support category which requires a more in-depth level of support. Please visit the below link to see the various paid support options that are available to better meet your needs.

    http://support.microsoft.com/default.aspx?id=fh;en-us;offerprophone

    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Jun Zh - MSFT Microsoft Online Community Support

    Thursday, January 16, 2014 9:27 AM

All replies

  • Any suggestions for Stig?

    Thanks!


    Ed Price, Power BI & SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!

    Tuesday, December 31, 2013 10:11 AM
  • Hi Stig,

    Thank you for your question. I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated. 

    Thank you for your understanding and support.

    Regards,


    Elvis Long
    TechNet Community Support

    Thursday, January 02, 2014 6:17 AM
  • Thanks Elvis. Looking forward to any input on this issue.

    Friday, January 03, 2014 8:45 AM
  • Hi,

    Your question falls into the paid support category which requires a more in-depth level of support. Please visit the below link to see the various paid support options that are available to better meet your needs.

    http://support.microsoft.com/default.aspx?id=fh;en-us;offerprophone

    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Jun Zh - MSFT Microsoft Online Community Support

    Thursday, January 16, 2014 9:27 AM