Help using SQl to limit the data being pulled form Microsoft Dynamics by Odata

Here is where you can input your SQL statement

The statement will be something like

SELECT
              name, _cha_clientid_value, _owningteam_value, duration, starttime, _cha_carercontactid_value, _msdyn_workorder_value, msdyn_totalcost, endtime, statuscode, msdyn_milestraveled, msdyn_actualarrivaltime

FROM

bookableresourcebookings

WHERE

              the condition on the start time and a final ;

here you find examples to build your syntax

https://www.w3schools.com/sql/sql_examples.asp

If this helped, please consider giving kudos and mark as a solution

me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI