Forum Discussion

indhaa's avatar
indhaa
New Member
5 years ago
Solved

Time Zone Issue

Hi,   I'm new to Power BI. I'm trying to set a Power BI Tile on Power Apps. So I created my data from SharePoint List and created the Report on Power BI desktop version. However after I created ev...
General Comment
Need Help
Tutorial Requests
  • ChrisMendoza's avatar
    ChrisMendoza
    5 years ago

    indhaa - I am pretty certain SharePoint returns UTC time for Date columns. Try using something like:

    DateTimeZone.ToLocal(DateTimeZone.From([MonthStart]))

ChrisMendoza's avatar
ChrisMendoza
Icon for Resident Rockstar rankResident Rockstar
5 years ago

indhaa - I am pretty certain SharePoint returns UTC time for Date columns. Try using something like:

DateTimeZone.ToLocal(DateTimeZone.From([MonthStart]))

  • ChrisMendoza's avatar
    ChrisMendoza
    Icon for Resident Rockstar rankResident Rockstar
    5 years ago

    indhaa -Your solution will depend on what you are getting too. 👀⤵