Last Refresh time data input not working in PowerBI Service?

Question

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 whenever why powerbi service do a refresh the time changes to something -6 or 5 hours or something, I am in +0530 GMT timezone, how can I eliminate this in order to get correct timezone in my powerbi service reports?

anmolgan · Answer

nahid3152&nbsp; 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:&nbsp;letSource = 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"&nbsp;But it gives me date in format of ddmmyy hh;mm;ss +00&nbsp;How can I remove +00 option from here? any ways to reformat this?

nahid3152 · Answer

HI,AnmolganUseNOW=FORMAT(UTCTODAY()+ TIME(6,0,0),"DD-MMM-YY")If time zone 6 then use 6 or use as per your requirement

mwegener · Answer

Hi&nbsp;Anmolgan&nbsp;,do you know the metadata (1) in the Power BI Service?https://powerbi.microsoft.com/en-us/blog/introducing-the-new-look-for-power-bi-service/Regards,MarcusDortmund - GermanyIf I answered your question, please mark my post as solution, this will also help others.Please give Kudos for support.

anmolgan · Answer

mwegener&nbsp;I dont need to see the last refresh in powerbi service, I want to see this in a visual inside my report, my external users do not have access to the powerbi service hence they will not be able to login to the powerbi service every time.