Forum Discussion

Anmolgan's avatar
Anmolgan
Post Prodigy
6 years ago

Last Refresh time data input not working in PowerBI Service?

I have added a query that contains my local date time the query is like this:   = DateTime.LocalNow   and created a table for this and am using that column inside my report, but the problem is wh...
Need Help
Show and Tell
nahid3152's avatar
nahid3152
Helper II
6 years ago
HI,Anmolgan
Use
NOW=FORMAT(UTCTODAY()+ TIME(6,0,0),"DD-MMM-YY")

If time zone 6 then use 6 or use as per your requirement
Anmolgan's avatar
Anmolgan
Post Prodigy
6 years ago

nahid3152  this does not works as it gives me only dates and I need date with time, I have made the below M query statments and it seems that it works with the powerbi service:

 

let
Source = DateTimeZone.UtcNow() + #duration(0,05,30,0),
#"Converted to Table" = #table(1, {{Source}}),
Column1 = #"Converted to Table"{0}[Column1],
#"Converted to Table1" = #table(1, {{Column1}}),
#"Renamed Columns" = Table.RenameColumns(#"Converted to Table1",{{"Column1", "Time"}})
in
#"Renamed Columns"

 

But it gives me date in format of ddmmyy hh;mm;ss +00

 

How can I remove +00 option from here? any ways to reformat this?

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    6 years ago

    Hi Anmolgan ,

    Please try to change the data type to Date/Time in Query Editor.

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anmolgan's avatar
      Anmolgan
      Post Prodigy
      6 years ago

      v-xuding-msft  mwegener  nahid3152 

       

      I had managed to set the refresh time according to my local time, but now the problem is the last refresh time is not able to match with the last refresh time which is shown in my powerbi service refresh history, I thought this is a problem with me creating an additional table, and the main query table not being refreshed so I tried to create a refrence measure inside my same master table, but still the refresh time does not match?

       

      Is there any way to solve this?