Forum Discussion

Hachi0805's avatar
Hachi0805
New Member
19 days ago
Solved

Power BI Service Semantic Model Refresh - date issue

Power BI Service shows different date than Power BI Desktop after Semantic Model refresh Environment Data Source: SharePoint List Power BI Desktop: Latest version Power BI Service Time Zone: Si...
Need Help
  • rohit1991's avatar
    rohit1991
    19 days ago

    Hii Hachi0805 

     

    Avoid DateTimeZone types altogether and use plain duration math instead, which isn't subject to the same folding reinterpretation:

    Table.TransformColumns(#"Renamed Columns", {
  {"StartDate", each if _ = null then null else Date.From(DateTime.From(_) + #duration(0,8,0,0)), type date},
  {"EndDate",   each if _ = null then null else Date.From(DateTime.From(_) + #duration(0,8,0,0)), type date}
})

rohit1991's avatar
rohit1991
Super User
19 days ago

Hii Hachi0805 

 

Avoid DateTimeZone types altogether and use plain duration math instead, which isn't subject to the same folding reinterpretation:

Table.TransformColumns(#"Renamed Columns", {
  {"StartDate", each if _ = null then null else Date.From(DateTime.From(_) + #duration(0,8,0,0)), type date},
  {"EndDate",   each if _ = null then null else Date.From(DateTime.From(_) + #duration(0,8,0,0)), type date}
})

Hachi0805's avatar
Hachi0805
New Member
19 days ago

Thank you Rohit. it works! now i can keep Singapore Time even after refresh deta model!! really appreciate your help.