Forum Discussion

singhv2's avatar
singhv2
Icon for Helper I rankHelper I
8 years ago
Solved

Connect a Peoplesoft "Query" (From Oracle Database) with Power BI

Hi Folks,   I am working on some regular ETL task and hence looking forward to adapt POWER BI capability(which is much more powerful).   Situation : For some task, we fetch report through a Peo...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • singhv2's avatar
    singhv2
    8 years ago

    Hi Yuliana,

     

    Instead of writing a SQL query (which might help, however, will take time as there is a lot of data to extract), we can use Direct Query, which connects the live data very quickly, instead of importing it. (I didn't know it earlier :)

     

    https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery

     

    Thanks for your support.

     

    Regards,

     

    Vikrant Singh

singhv2's avatar
singhv2
Icon for Helper I rankHelper I
8 years ago

Great.. :) I'll try doing it and get back to you, in case of any issues :)

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi singhv2,

 

Have you worked it out? If yes, would you please kindly accept the helpful reply as a solution or share your valid solution? If you still have any question, please feel free to ask.

 

Regards,
Yuliana Gu