Date Range from source data

[cswargam]

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 data. Now, it is only showing 14 days worth data. 

My question: How can I increase the date range to pull more than 14 days date range from the source data. 

Appreciate any help to solve this as I am stuck not able to see very old data for future data. 

Thanks

Chandra

[cswargam]

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]

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.

[bcdobbs]

If you click on Transform Data

it will take you into query editor where you can amend the steps.