Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Hello, DECODE is not supported in PowerBI ? Really ?
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
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.
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.