locked
Excel AddIn 2013 build 12.0.2468.0 - is this a bug? RRS feed

  • General discussion

  • Excel AddIn 2013 64x,  build 12.0.2468.0

    If open the Excel workbook with connecting to MSSQL and then open the Excel workbook with MDS - data are not extracted from MDS.

    Is this a bug?

    If open the Excel workbook with connection to the MDS and then open the Excel workbook with connecting to MSSQL - data is retrieved from MDS successfully!

             

    from Moscow with money

    Thursday, April 2, 2015 7:23 PM

All replies

  • Can you provide more detail repro step?
    What's "connecting to MSSQL"? Is it DATA Tab->From Other Sources -> From SQL Server?

    Thursday, April 2, 2015 7:57 PM
  • Vincent,

    Yes, exactly



    from Moscow with money

    Thursday, April 2, 2015 9:42 PM
  • I am not able to repro the issue.
    Here is my repro step.
    1. Open a new Excel
    2. In Sheet1, DATA Tab->From Other Sources -> From SQL Server, Import a table from a SQLServer database.
    I used the exact same MDS database, the MDS service is using.
    3. Add Sheet2, MASTER DATA -> Connect, Import an entity.

    Both of the sheets have the data imported.
    Did you do anything different?

    Thursday, April 2, 2015 10:28 PM
  • Vincent,

    I did step 3  (MASTER DATA) both in the same book, and in another separate Excel file

    The connection is successful, but import data of entity from MDS Server - no. I click and no there are no errors. And ....no data are requested from the server.

    We tried it on different computers.


    from Moscow with money

    Friday, April 3, 2015 7:35 PM
  • Could you please provide us the exact detailed step by step repro? Because we are not able to repro the issue.

    Thank you.

    Monday, April 6, 2015 5:16 PM