Oracle SQL Queries

[DouweMeer]

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. 

[Vanessa250919]

Hello, DECODE is not supported in PowerBI ?  Really  ? 

[v-juanli-msft]

Hi @DouweMeer 

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/

If the SQL queries limit the data when importing to Power BI, you could paste the SQL queries in "Sql statement" window 

Best Regards
Maggie

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

[DouweMeer]

Hello Maggie,

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. 

[v-juanli-msft]

Hi @DouweMeer 

Could you share the SQL queries and your requirement here?

Best Regards
Maggie

[DouweMeer]

Hello Maggie,

I've send you a PM with the SQL as it is very big. 

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. 

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.