Post reply

SQLServerCentral Hosts AdventureWorks on Azure

  • May 20, 2013 at 12:05 am

    #274088

    Comments posted to this topic are about the item SQLServerCentral Hosts AdventureWorks on Azure

  • May 23, 2013 at 12:45 pm

    #1618001

    Just tried connecting using Powerpivot. Most of the tables get you a 'invalid object name' error.

    There are only a few that are query-able through Powerpivot =(

  • May 23, 2013 at 12:49 pm

    #1618004

    That's interesting. Which are and which aren't?

  • May 23, 2013 at 12:58 pm

    #1618009

    pretty hard to tell since what Powerpivot does is that if it encounters just 1 that gives an error it gives you an error for the rest of the tables. In other words, it kills the rest of the process because it encountered that "critical" error.

    So far, I've been able to load these tables:

    AWBuildVersion

    SqlFamily

    bigProduct

    but none of the actual AW database. The views are loading just fine tho like vSalesPerson.

    Could it be something with the access that the user has for those tables?

    --

    @migueldotxlsx

  • May 23, 2013 at 1:37 pm

    #1618026

    Interesting enough, that was done through the Powerpivot import tables wizard but...If instead of using the Wizard I create a simple query like:

    SELECT *

    FROM

    Sales.SalesOrderDetail AS SalesOrderDetail

    Then it retrieves 121,317 rows of the table.

    Note that the actual Table Import Wizard should not have this type of issues with SQL Azure (according to MSFT).

  • April 19, 2018 at 8:00 pm

    #1987617

    Out of curiosity, is this database ever refreshed? I noticed that there are several schema/objects that aren't part of AdventureWorks.

  • April 20, 2018 at 8:08 am

    #1987671

    We haven't refreshed it in a long time. I think we used whatever version of ADW was out at that time.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply