Forum Discussion
Anonymous
7 years agoNot applicable
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
Hi Anonymous
You can define SQL statement in the box below
3 Replies
- Zubair_MuhammadCommunity Champion
Hi Anonymous
You can define SQL statement in the box below
- AnonymousNot applicable
thanks Zubair_Muhammad if i have multiple querys how i can execute multiple at a time?
- v-chuncz-msftCommunity Support