Forum Discussion
ORA-01427 error while GetData PowerBI
Hello Everyone,
I am facing a very uncommon issue which makes me lost here.
I have a view in Oracle database. I tried to get that view in PowerBi desktop to make some report over it.
But while cliking the view from the list of objects it gives me below error.
DataSource.Error: Oracle: ORA-01427: single-row subquery returns more than one rowI am wondering this ORA error I have seen thousand times in my database work and resolved it. But not sure while loading the table why it comes and how it comes.
This view is valid view, I have checked from database, it gives me data from select statement. This is is based on two different tables but both are in union, no subquery present in there.
Here is the view details
If anyone else get similar error in PowerBI please help me to resolve this.
Thanks,
Bithun
2 Replies
Hi goldenbutter ,
I found these articles about solving ORA-01427 error, please refer to
Oracle: ORA-01427: Subquery returns more than one row
Oracle / PLSQL: ORA-01427 Error Message
How to Resolve ORA-01427: single-row subquery returns more than one row
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi goldenbutter ,
Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.
Best Regards,
Stephen Tao
