Forum Discussion

n4tusi4's avatar
n4tusi4
Regular Visitor
4 years ago
Solved

Oracle: ORA-00911: invalid character in query

Hello, Can You please help me to identify what power BI treats as an invalid character in this query? I can add that it works fine in SQL developer. I have already removed all "%", ";"   and "&". Ma...
Need Help
Show and Tell
  • n4tusi4's avatar
    n4tusi4
    4 years ago

    The issue was created by the same name of 2 different columns. I have changed a name of 2nd one and now it works.

    SELECT distinct (
    SELECT sob.NAME
    FROM apps.gl_sets_of_books sob
    WHERE sob.set_of_books_id = a.set_of_books_id
    ) "SOB_Name"
    ,(
    SELECT sob.set_of_books_id
    FROM apps.gl_sets_of_books sob
    WHERE sob.set_of_books_id = a.set_of_books_id
    ) "SOB_Name"
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi， n4tusi4

May be here. try to change left join.

If a special character other than $, _, and # is used in the name of a column or table, the name must be enclosed in double quotations. Link


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • n4tusi4's avatar
    n4tusi4
    Regular Visitor
    4 years ago

    Hello v-yalanwu-msft ,

    Unfortunately it didn't help. + is allowed sign from what I can see on my previous queries. What is funny about this query - it worked on previous dashboard but I assume, my colleague worked on older version of power BI.