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

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 III
Super User III

Re: RE: direct query

Hi @Chanty4u

 

You can define SQL statement in the box below

 

 

chanty1.png

Try my new Power BI game Cross the River

View solution in original post

Community Support
Community Support

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.

View solution in original post

3 REPLIES 3
Super User III
Super User III

Re: RE: direct query

Hi @Chanty4u

 

You can define SQL statement in the box below

 

 

chanty1.png

Try my new Power BI game Cross the River

View solution in original post

Chanty4u Helper V
Helper V

Re: RE: direct query

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

Community Support
Community Support

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.

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors