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 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

Need Help

3 Replies

  • bcdobbs's avatar
    bcdobbs
    Community Champion
    4 years ago

    If you click on Transform Data

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

  • 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.