Power BI Oracle Connection issue - oracle: ora-01422:

[ShalaniK]

Hi All,

When I try to run a simple select query in power bi I am getting the below shown error message. I have connected to a Oracle DB other connections are working fine except for this view. Appreciate very much if you could help me out with this. 

the query i am trying to run is :

SELECT *
FROM SLC_JEL_EXPENSES__BUDGETS_V
WHERE PERIOD_NAME NOT LIKE 'ADJ%'
AND SEGMENT2 NOT LIKE 'T'
AND PERIOD_NAME LIKE '%23%'

[Anonymous · Accepted solution]

Hi @ShalaniK ,

Thanks for reaching out to us with your problem. The error ORA-01422 typically occurs when a SQL statement retrieves more rows than expected. Please update your T-SQL statement as below to limit the returned rows in less count and check if it can load the data successfully.

SELECT *
FROM SLC_JEL_EXPENSES__BUDGETS_V
WHERE PERIOD_NAME NOT LIKE 'ADJ%'
AND SEGMENT2 NOT LIKE 'T'
AND PERIOD_NAME LIKE '%23%'
AND ROWNUM <= 100

In addition, please review the following official documentation and check if you already follow these steps to connect Oracle.

Power Query Oracle database connector - Power Query | Microsoft Learn

Best Regards