Forum Discussion

bvpenumalli's avatar
bvpenumalli
New Member
7 years ago

Time Stamp missing - PowerBI SSAS cube live connection

I have PowerBI report that is connected to SSAS cube via live connection. When I browse cube through SSMS it shows time stamp in the data column, but in the PowerBI report it is missing the time sta...
Need Help
suhasakole's avatar
suhasakole
Frequent Visitor
7 years ago

Hi bvpenumalli 

 

Can you check the data type of your column? if its only Date then it will show only date. Please change to Date/Time to get the time stamp.

 

Hope this will help you.

  • bvpenumalli's avatar
    bvpenumalli
    New Member
    7 years ago

    Thank you for your response, it is set as DateTime in SSAS cube, when I browse SSAS cube via SSMS it shows as date time.

    • bvpenumalli's avatar
      bvpenumalli
      New Member
      7 years ago

      Where in PowerBI we can specifically set data type ?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        If its live connection to SSAS, you cant modify the data type, that needs to be handled in the tabular model or you may need to create a report level measures to set data type.