Forum Discussion

ShalaniK's avatar
ShalaniK
New Member
2 years ago
Solved

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

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%'

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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