Forum Discussion

homboy27's avatar
homboy27
Helper III
1 year ago
Solved

Updating Date in Parameters

Does anyone know if it is possible to have the date be auto updated to be todays date in power bi parameters? I refresh a report everyday on workspace server and would like the date to always be todays date rather than always having to updating it manually everyday. 

  • Hi homboy27 

    May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

    Thank you.

4 Replies

  • Deku's avatar
    Deku
    Super User

    In powerquery add a table with a single column with DateTime.LocalNow, this will update on every refresh

    • homboy27's avatar
      homboy27
      Helper III

      How do I get that to update in parameters? and will it work if the dashboard is being refreshed automatically on workspace?

      • Deku's avatar
        Deku
        Super User

        Don't need parameters and will automatically update when dataset refreshes 

  • v-priyankata's avatar
    v-priyankata
    Community Support

    Hi homboy27 

    May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

    Thank you.