Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Query works in Oracle SQL Developer, but not in Power BI

Hi, I am trying to get data in Power BI. My query works in Oracle SQL Developer, but in PBI I get an error "Details: "Oracle: ORA-00900: invalid SQL statement".   I noticed in Oracle SQL Dev, ther...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous 

    The SQL part will need to be re written
    as One query per call is excutes and all the statements begining with define is a statement in itself.
    Also, "&&value1" will need an input in Developer and if you have provided it once it may not ask untill session is reset. However, this cannot be carried over to PBO query editor. 

    You may need to work on parameters instead to achieve the "&&" functionality.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous 

The SQL part will need to be re written
as One query per call is excutes and all the statements begining with define is a statement in itself.
Also, "&&value1" will need an input in Developer and if you have provided it once it may not ask untill session is reset. However, this cannot be carried over to PBO query editor. 

You may need to work on parameters instead to achieve the "&&" functionality.