Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Date/Time Field

    Posted 15 days ago

    Hi All,

    I have a web source that includes a date/time field in text form, like this: 10-15-2021 02:16:00. I have to do text substitution ( / for - ) before I can change the data type to date/time. However, when I publish to Power BI Service, it doesn't adjust for the different timezone the way other data sources do. I think this is because it is still stored originally as a text field. This creates problems when I try to do diff calculations on date/time fields across sources. I can get it to work on my laptop but it's off on PBI Service.

    First, is my understanding of how the data is stored correct, and is there anything I can do about it, like force Power Query to store it as a true date/time field instead of text? I suspect I could with a custom connector, but that's a little over my head right now.

    Thanks,
    Bill



    ------------------------------
    Bill Kellam
    ------------------------------