8. května 2012 8:50
I am connecting to a SQL Azure data source from power pivot. I have my reporting tables grouped under a schema other than dbo, let's have the schema name as sch for illustrative purposes. The Table Import Wizard in powerpivot shows me the tables under sch schema, but there is no separate column displaying the schema name as with SQL 2008 R2. When I select the table and click finish, I get an error saying,
Failed to retrieve data from <Tablename>. Reason: Invalid object name '<Tablename>'
But when I write the query instead of selecting from the list of tables, I am able to get the data. This is the query:
SELECT * FROM sch.<Tablename>
So looks like the Table Import Wizard is not recognising the schemas in Azure. Please let me know if there is any workaround for this other than writing queries for selecting the objects.
8. května 2012 9:11
I can't reproduce this; for me it works fine.
And I have a separate column for the schema name, where I also can sort by. Have you installed the latest release of PP SQL Server 2012 RTM?
8. května 2012 12:35
I am using the latest version of powerpivot. And I am able to see the schema column when I connect to an on-prem sql 2008 r2 database. I face this issue only when connecting to Azure. Not sure if there are any settings to be configured for Azure.
- Upravený sqldba_123 9. května 2012 1:05
9. května 2012 15:16
hi please go through the below link, it may help you.