Forum Discussion

singhv2's avatar
singhv2
Helper 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
Helper I
8 years ago

Hi Yuliana,

 

Somehow, the SQL query method is not working, and I am getting some sort of error. I'll share the screenshot with you.

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

Hi singhv2,

 

What is the error message? Can you run the same query successfully in Oracle Database?

 

Regards,
Yuliana Gu

  • singhv2's avatar
    singhv2
    Helper I
    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