Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

SSAS Tabular DateTime not showing as DateTime when Desktop uploaded to Web

Hi,

 

I've got an issue whereby I'm connecting via DirectQuery to a Tabular (2014 Enterprise) model with a Date column which contains datetime, I've set it as a date table and when I build a line chart with a metric using PowerBI Desktop, the line values are correctly displayed by time (days,hours,mins etc).  But when I deploy to the PowerBI service, the time is lost and is set to 12:00:00.

 

I've tried setting the date to various date display formats and also removed/added it as a date table but no joy.

 

Does anyone know what the issue could be?

 

Thanks

Need Help

7 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    10 years ago

    Anonymous

     

    I haven't reproduced your issue. The datatime from Tabular data source is rendered properly after we publish it onto Power BI Service. My environment is SSAS 2014 Enterprise + Power BI Desktop May Update (2.35.4399.381).

     

    Regards,

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Hi, what were the Tabular column settings for that datetime column?  Thanks

      • v-sihou-msft's avatar
        v-sihou-msft
        Microsoft Employee
        10 years ago

        Anonymous

         

        It's live connection, we can't set anything on column. In my source table, it's just a datetime column. As I change table into line chart, it can still dispaly datetime value properly. But on axis, it only shows 12AM and 12PM.

         

        Regards,