cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Chanty4u Member
Member

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: RE: direct query

Hi @Chanty4u

 

You can define SQL statement in the box below

 

 

chanty1.png

Community Support Team
Community Support Team

Re: RE: direct query

@Chanty4u,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Super User
Super User

Re: RE: direct query

Hi @Chanty4u

 

You can define SQL statement in the box below

 

 

chanty1.png

Chanty4u Member
Member

Re: RE: direct query

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

Community Support Team
Community Support Team

Re: RE: direct query

@Chanty4u,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.