ORA-01427 error while GetData PowerBI

[goldenbutter]

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 row

I 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

[v-stephen-msft]

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

[v-stephen-msft]

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.