Forum Discussion
Connect a Peoplesoft "Query" (From Oracle Database) with Power BI
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
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
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.
Hi singhv2,
What is the error message? Can you run the same query successfully in Oracle Database?
Regards,
Yuliana GuHi 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