Last Refresh time data input not working in PowerBI Service?

[Anmolgan]

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?

[mwegener]

Hi @Anmolgan ,

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,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[Anmolgan]

@mwegener 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.

[nahid3152]

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]

@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]

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]

@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?

[v-xuding-msft]

Hi @Anmolgan ,

Maybe the blog can help you.

https://www.excelguru.ca/blog/2016/06/08/display-last-refreshed-date-in-power-bi/

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.