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 c...
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi,

 

Here's my Tabular model column and the type/formatting, there's the Desktop table showing dates and times correctly, but once it's uploaded to the Service, all the times are set to midnight:

 

palzor's avatar
palzor
Regular Visitor
10 years ago

Hi, 

I am also facing the same issue. Anonymous did you manage to solve it?

 

thanks

Palzor 

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi Palzor,

     

    This is now working for me.  SSAS Tabular 2014 (Enterprise) in DirectQuery mode and both Power BI Desktop and the Service are showing datetimes correctly in tables and line charts.  I've installed the new On-Premise Gateway so I wonder if that's had anything to do with fixing it.

     

     

    • palzor's avatar
      palzor
      Regular Visitor
      10 years ago

      Hi Andy,

      thanks for the reply. Yes installing On-Premise Gateway solved the problem.

       

      Thanks

      Palzor