Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.