PowerPivot 2012 with SQL Azure

Question

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.

Thanks

Answer 1

Hello,

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?

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

Hi

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.

Thanks

Answer 3

hi please go through the below link, it may help you.

http://thinknook.com/sql-azure-labs-data-explorer-tool-2012-04-18/