Today's date not refreshing in Power BI Service

Power BI Online Service
1

Hi all,

I have the following M code for Date Refreshed but it is not being refreshed even when I have daily scheduled refreshes for my dataflows and datasets. Where am I going wrong and why isn’t the report refreshes. I do not want to manually refresh everyday.

Thanks for your help.

let
Source = #table(type table[Date Last Refreshed=datetime], {{DateTime.LocalNow()}}),
#“Changed Type” = Table.TransformColumnTypes(Source,{{“Date Last Refreshed”, type date}}),
#“Renamed Columns” = Table.RenameColumns(#“Changed Type”,{{“Date Last Refreshed”, “Date Refreshed”}})
in
#“Renamed Columns”

image
image494×523 8.97 KB

image
image1376×165 12.6 KB

image

2

Hi @ysherriff, thanks for posting your query. While waiting for others to jump in, kindly take time to watch this video tutorial by @JarrettM on how to “Get Updated Last Refresh Date And Time In Power BI”

I hope this helps.

1 Like