Forum Discussion

yijichen's avatar
yijichen
Microsoft Employee
10 years ago

Timestamp only have date when directly connect to SQL database through Powerbi.com

Hi PowerBI Team,   When connecting to SQL database directly from pwerbi.com, the visualization will lose the time part from the timestamp. For example, 2015-08-01 14:00 will become 2015-08-01. Is...
Need Help
yijichen's avatar
yijichen
Microsoft Employee
10 years ago

I tried that and it is still not working. I guess we need to wait PowerBI team to response this issue.

Enrico's avatar
Enrico
Frequent Visitor
10 years ago

Same here. We have an Import from Azure Stream Analytics. Timestamp has the format (system.timestamp) like "2015-10-20T08:52:16.000Z" but in Power BI Dashboard or Report we se only the date "2015-10-20". Any idea why?

  • fadi's avatar
    fadi
    Microsoft Employee
    10 years ago

    Has this issue been solved yet?

     

    I am having the same problem publishing a timestamp column via Azure Stream Anaytics.

     

    Thanks.

    • Enrico's avatar
      Enrico
      Frequent Visitor
      10 years ago

      Now it is solved. You can see a real timestamp on your data in PBI from ASA. Could be that you need to delete your existing Report.

      • Jeyakumar_Raman's avatar
        Jeyakumar_Raman
        Frequent Visitor
        10 years ago

        I am still having this issue. It was working fine until April 2016, anything changed recently?