Oracle SQL Queries

Question

I'm receiving SQL queries from our IT. However they are massive and written for the Oracle database. Functions like decode or the symbol (+) are not supported, but it is a pain to rewrite them.

I was hoping there exists a tool that transforms Oracle SQL queries to SQL queries supported by Power Query.

Edit: (+) is supported.

v-juanli-msft · Answer

Hi&nbsp;DouweMeer&nbsp;
As far as i known, there is no such tool.
There are some articles about SQL to DAX or Power Query
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
https://sqlserverbi.blog/2018/05/12/sql-m-or-dax/
&nbsp;
If the SQL queries limit the data when importing to Power BI, you could paste the SQL queries in "Sql statement" window&nbsp;

Best RegardsMaggie
Community Support Team _ Maggie LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

douwemeer · Answer

Hello Maggie,&nbsp;Was what I meant. When I copy paste the SQL query in the SQL statement it doesn't work, thus having me to rewrite it.&nbsp;

v-juanli-msft · Answer

Hi&nbsp;DouweMeer&nbsp;
Could you share the SQL queries and your requirement here?
&nbsp;
Best RegardsMaggie
&nbsp;

douwemeer · Answer

Hello Maggie,I've send you a PM with the SQL as it is very big.&nbsp;What I want is make sure I don't need to run the query manually on the Oracle software platform anymore but rather import it via Power Query.&nbsp;It seems that there are certain symbols and functions allowed for an Oracle query which is not for Power Query. Also it seems that sometimes I need to use ' in Oracle, while it is " in Power Query. However, sometimes it is ' in Power Query as well.

vanessa250919 · Answer

Hello, DECODE is not supported in PowerBI ?&nbsp; Really&nbsp; ?&nbsp;

Forum Discussion

Oracle SQL Queries

5 Replies

Related content

SQL Query Syntax issue

Native SQL query for Power BI

Query works in Oracle SQL, but PowerBI returns nothing

SQL Query generation in Direct Query

Power Query or SQL