Forum Discussion

Pankhuri_16's avatar
Pankhuri_16
Frequent Visitor
2 years ago
Solved

Database refresh date and power bi refresh date

Does anyone have an idea for a dax measure to find out when our database was last refreshed and when our power bi report was last refreshed. There are times when database gets refreshed but power bi ...
Need Help
  • talespin's avatar
    talespin
    2 years ago

    hi Pankhuri_16 

     

    Step1: You can use GetDate function in SQL Server and store that date only after all necessary tables have refreshed.

     

    Step2: Capture date during Power BI refresh, please note that by default when you refresh your dataset on Power BI service, it returns datetime in UTC, so it may differ from your date time captured on SQL Server. You will need to make sure Date returned by Power BI service is per your timezone by converting it(Check Timezone functions in PowerQuery). 

Pankhuri_16's avatar
Pankhuri_16
Frequent Visitor
2 years ago

How do we store database refresh date in any table on sql server ?

  • talespin's avatar
    talespin
    Solution Sage
    2 years ago

    hi Pankhuri_16 

     

    Step1: You can use GetDate function in SQL Server and store that date only after all necessary tables have refreshed.

     

    Step2: Capture date during Power BI refresh, please note that by default when you refresh your dataset on Power BI service, it returns datetime in UTC, so it may differ from your date time captured on SQL Server. You will need to make sure Date returned by Power BI service is per your timezone by converting it(Check Timezone functions in PowerQuery).