Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

RE: direct query

Hi All,

 

i have   sql server database query.   i want to run this query directly in  Power BI

 

is it possible?   if yes how can i do this?  

 

select region,UM(Hardware_Order_US_Dollar_Amount)HW_ORD, SUM(Service_Order_US_Dollar_Amount)SW_ORd,

 SUM(Total_Order_US_Dollar_Amount)Total_Order  from PERSONAL_SYSTEMS_DAAS.vw_TCV_Vs_Daas_Orders

 WHERE Quarter in('2018Q1','2018Q2','2018Q3') group by REGION

 

Best

chanty

3 Replies