cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
DouweMeer Member
Member

Oracle SQL Queries

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. 

4 REPLIES 4
Community Support Team
Community Support Team

Re: Oracle SQL Queries

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 

Capture5.JPG

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 Member
Member

Re: Oracle SQL Queries

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. 

Community Support Team
Community Support Team

Re: Oracle SQL Queries

Hi @DouweMeer 

Could you share the SQL queries and your requirement here?

 

Best Regards
Maggie

 

DouweMeer Member
Member

Re: Oracle SQL Queries

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.

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 54 members 874 guests
Please welcome our newest community members: