Forum Discussion

cswargam's avatar
cswargam
Regular Visitor
4 years ago

Date Range from source data

Hello everyone,  I have connected to Power BI and imported data from one of our databases. However, initially I gave 7 days previous to 7 days after from the current date to pull from the source dat...
Need Help
cswargam's avatar
cswargam
Regular Visitor
4 years ago

I have loaded the data and click on Transfor data, not sure where I can find the button to edit the date range. See below screenshot and advise. Much appreciate to guide me to change the date range from the source file. 

 

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi cswargam 

    Go to Advanced Editor and change the date range,

    Or if you use the Sql Statement (optional), go to change its setting 

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.