PowerPivot import data from oracle database

Question

Hi,

I am trying to import data from oracle database in PowerPivot Excel 2010 version.(Import from other sources->Oracle->Test connection->Succedded).Instead of all tables I used Query builder window and wrote my own query consisting 5,6 tables.It's showing "0 rows imported" whereas same query returning >1000 rows when ran it in Toad with same user id password.

When I am writing the query select * from only one table 1 then it's importing data but in my actual query 5,6 tables are getting joined and group by statement is there.It's importing 0 rows.

Can you please help me to understand why this is happening and how should I troubleshoot this.

This query is taking 1 min 30 secs to resturn result in Toad(result >1000 ).

Thanks in advance

Mousumi



Answer 1

Hi,

I am trying to import from oracle database (Get other sources->Oracle->Test connection succedded).Instead of direct table import i used query builder window and wrote a query where 5,6 tables are getting joined.It's showing "0 rows imported" whereas I am getting 1059 rows when I am running the same query in Toad with same user id password.

I tried to write the query select * from table1(single table) then it's getting data but in actual query(5,6 table joins) group by it's importing 0 rows.

Do you have any idea why this is happening?

This query is taking 1 min 30 secs in Toad to return 1059 records.

Answer 2

Hi Mousumi,

Could you please show us your Query?

---

Challen Fu

TechNet Community Support

Answer 3

Do you have any comments in the query?  If so, remove the comments and try again.  Some other ideas include removing additional empty lines and no trailing semicolon.  The query builder is quite tempermental and I have done all of these to get the Oracle query working properly. 

For the record, it does work with joins and complex queries.  If you need me to troubleshoot the query more closely include the query syntax here.

---

Regards, Steve @dataonwheels http://www.dataonwheels.com

Answer 4

hi you can also ask your query to the below forum, it may help you for the same.

http://kbalertz.com/981593/Import-operation-fails-import-Oracle-database-PowerPivot-Excel.aspx

Answer 5

Thanks ..it got solve..My query has a date parameter which it was not able to read .I change the date with TO_DATE function and it is importing rows.