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

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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft 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

  • 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