Forum Discussion
SQL to Power Query Translation
Hi everyody. I have an sql statement that I run on SQL Developer and it returns the results I want.
I have the tables as direct query in Power BI. I have created the relationship, one ORDH to many DELV. However when I go to a visual I do not get the records I want. How would I translate this into Power Query?
select sum(o.charges),count(o.order_nbr)
from ordh o
inner join delv d on d.order_nbr = o.order_nbr
where d.status = 'D'
and d.status_DATE)= CURRENT_DATE
Also is there a way to reference the current_date in power query?
Thanks for any help.
If you want, you can also pass a query directly in Power BI
You just have to click on advanced options and paste your query
My SQL Editor is based on an Oracle database but does not reside in the database. I am not allowed to create or save views in the database. What would I choose as a data source? Do I save that query as text? I am sorry for what may seem like a silly question but I am extremely new to PowerBI and DAX
wow. that worked like a charm. thank you so very much. That is going to help a ton!
4 Replies
wow. that worked like a charm. thank you so very much. That is going to help a ton!
- Cookistador
Super User
If you want, you can also pass a query directly in Power BI
You just have to click on advanced options and paste your query
My SQL Editor is based on an Oracle database but does not reside in the database. I am not allowed to create or save views in the database. What would I choose as a data source? Do I save that query as text? I am sorry for what may seem like a silly question but I am extremely new to PowerBI and DAX
well shoot. It worked and shows in Desktop but when I publish it I get an error that I am disconnected. Is there something else I need to do?