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.
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.
Solved! Go to Solution.
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!
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?
wow. that worked like a charm. thank you so very much. That is going to help a ton!
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
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