Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQLServerCentral Hosts AdventureWorks on Azure Expand / Collapse
Author
Message
Posted Monday, May 20, 2013 12:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 15, 2008 7:24 AM
Points: 0, Visits: 0
Comments posted to this topic are about the item SQLServerCentral Hosts AdventureWorks on Azure
Post #1454408
Posted Thursday, May 23, 2013 12:45 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, May 25, 2013 3:26 AM
Points: 3, Visits: 6
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 =(
Post #1456172
Posted Thursday, May 23, 2013 12:49 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 3:49 PM
Points: 31,161, Visits: 15,607
That's interesting. Which are and which aren't?








Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1456176
Posted Thursday, May 23, 2013 12:58 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, May 25, 2013 3:26 AM
Points: 3, Visits: 6
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
Post #1456181
Posted Thursday, May 23, 2013 1:37 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, May 25, 2013 3:26 AM
Points: 3, Visits: 6
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).
Post #1456203
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse