Forum Discussion

jacccodezwart's avatar
jacccodezwart
Icon for Helper I rankHelper I
3 years ago
Solved

Dashboard unable to refresh

Hi there,   We have Power BI reporting server May 2022 version (we plan upgrade soon).   On this server we have a report which is unable to refresh. It produces the following message.   DataFor...
"scheduled refresh"
"Time Zone"
  • lbendlin's avatar
    lbendlin
    3 years ago

     

    Later this value is converted using ' DateTimeZone.FromText(DateFilter)'.

     

    What made you do that?  The original value seems to be just fine?

     

     

    let
    Source = #table({"Column1"},{{"2019-12-31T23:59:59.99Z"}}),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type datetimezone}})
in
    #"Changed Type"

     

    How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done".

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

 

Later this value is converted using ' DateTimeZone.FromText(DateFilter)'.

 

What made you do that?  The original value seems to be just fine?

 

 

let
    Source = #table({"Column1"},{{"2019-12-31T23:59:59.99Z"}}),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type datetimezone}})
in
    #"Changed Type"

 

How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done".

  • jacccodezwart's avatar
    jacccodezwart
    Icon for Helper I rankHelper I
    3 years ago

    Thanks for you response. Your solution works.

     

    Jacco