Forum Discussion
Is it possible to include multiple SQL-Statements in one query (ORACLE)?
Hi folks, usually, working with an oracle database in a standard SQL-editor multiple sql-statements can be entered in one query separated by a semicolon. However, when I try to do that in Power B...
Hi Nico,
Can you just send me that query?
Because, Power BI will not support ;(semicolon) in SQL Editor. You need to have oracle connector to establish the connection with Oracle DB.
If you are using SQL Editor for your Oracle query, then it is wrong.
Or, you can split these two tables and make relations in the data model and then move to further development.
Regards,
Pradeep
Thanks a lot for you comment!
You have saved a lot of days searching for the resolution of my problem!