Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Automatically updating datess in SQL code

Hello,   We're importing tables from a SQL server and are running some SQL before it's imported from the "SQL Server Database" window and using the "Advanced Options">"SQL Statement" box into Power...
Need Help
  • RobbeVL's avatar
    RobbeVL
    7 years ago

    Have a Look at GETDATE() in SQL.

    Will give you the current DateTime

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks for your quick reply.

 

Sorry stupid question: How would I do that?

 

Thanks

 

Stuart

RobbeVL's avatar
RobbeVL
Impactful Individual
7 years ago

Have a Look at GETDATE() in SQL.

Will give you the current DateTime

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Ah right, For some season I thought these functions wouldn't work in Power BI.

     

    Thanks

    • RobbeVL's avatar
      RobbeVL
      Impactful Individual
      7 years ago

      The Query will still be run in your Database, PowerBI just sends the query and retreives the data.
      Good luck!