I design a simple query to extract data from Oracle Database. This query is giving me the correct output through TOAD.
The query is;
select A.JE_HEADER_ID, B.EFFECTIVE_DATE
from gl.gl_je_headers a, gl.gl_je_lines b
I used the same query in PowerPivot data Manage through get data from other sources.
Kindly help me to get the date format to get the correct output through powerpivot.