Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi folks,
Can anybody advise on this, please?
I've seen a thread using this formula: = DateTime.Time(DateTime.LocalNow()) & DateTime.Date(DateTime.LocalNow())
but for the life of me I can't figure out how to use it. How to create this table?
Big thanks,
Alice
Solved! Go to Solution.
In the main PowerBI window, in the Home ribbon:
Get Data => Blank Query
A new window should open (Query Editor), within that window go to the Home ribbon then Advanced Editor
A new window will open with the code like this
let Source = "" in Source
replace it with the one I posted before, click Done, then Close & Apply
you can create a new table in M, that when loaded to the model will give you the refresh time, e.g. like this
let Source = #table({"Last refresh"}, {{DateTime.Time(DateTime.LocalNow()) & DateTime.Date(DateTime.LocalNow())}}), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Last refresh", type datetime}}) in #"Changed Type"
Hi Stachu,
How do I create that table? Do I use the 'Enter Data' button? Where do I enter the formula you've provided?
Thanks!!
I've also tried 'New table' in the Modelling tab, but I get an error
In the main PowerBI window, in the Home ribbon:
Get Data => Blank Query
A new window should open (Query Editor), within that window go to the Home ribbon then Advanced Editor
A new window will open with the code like this
let Source = "" in Source
replace it with the one I posted before, click Done, then Close & Apply
I've missed the part about 'Advanced Editor'. It works!!! Thank you so much!
glad to hear that 🙂
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
77 | |
60 | |
52 |
User | Count |
---|---|
165 | |
86 | |
68 | |
68 | |
58 |