27 April 2012 15:14
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
27 April 2012 3:41
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.
- Digabungkan oleh Challen FuModerator 30 April 2012 7:15 duplicated thread
30 April 2012 5:13Moderator
30 April 2012 16:02
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
- Ditandai sebagai Jawaban oleh Challen FuModerator 08 Mei 2012 10:11
02 Mei 2012 8:37
hi you can also ask your query to the below forum, it may help you for the same.
05 Juli 2012 13:31Thanks ..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.