RE: direct query

[Anonymous]

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

[Zubair_Muhammad · Accepted solution]

Hi @Anonymous

You can define SQL statement in the box below

[Zubair_Muhammad · Accepted solution]

Hi @Anonymous

You can define SQL statement in the box below

[Anonymous]

thanks @Zubair_Muhammad if i have multiple querys how i can execute multiple at a time?

[v-chuncz-msft · Accepted solution]

@Anonymous,

Just add a new query and change code in The Advanced Editor.