Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Hi @Anonymous
You can define SQL statement in the box below
@Anonymous,
Just add a new query and change code in The Advanced Editor.
Hi @Anonymous
You can define SQL statement in the box below
thanks @Zubair_Muhammad if i have multiple querys how i can execute multiple at a time?
@Anonymous,
Just add a new query and change code in The Advanced Editor.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |