VS 2012 Pro - Import from Powerpivot - Analysis Services


  • VS2012 Pro environment, with the SQL2012 support for Analysis Services installed (including the Aug.2013 update for SSDT).

    Trying to open an Excel/Powerpivot which should be straightforward.

    But still I'm unable to connect to the server and when I goto Tools>Options>Analysis Services Tabular Designers - I see "localhost" as the default server and the "Test Connection" button produces a fail each time.

    Tried changing localhost to my machine's name and dozens of other permutations but still unable to connect.

    Is there a fix for that at all?


    Monday, September 16, 2013 2:07 AM