Forum Discussion

ShmuelM's avatar
ShmuelM
Advocate II
9 years ago
Solved

Live Connection To Analysis Services does not show date hirarchy

Hi ,  When I am connecting to Analisys Services in Live Mode ( I tried to Azure and to On-Prem as well) When I select a date / datetime column PowerBI does not recognize it as a date , It also does ...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    9 years ago

    ShmuelM The Auto-Date feature doesn't work when you are using a SSAS live connection. It is assumed that you would build your own date tables in the model. To simplify this further, you could use DAX to create your date tables, it isn't much work at all. Power BI should be recognizing all your date/time data types, are you certain you have them set appropriately in the SSAS model?

ShmuelM's avatar
ShmuelM
Advocate II
9 years ago

Anonymous Hi , 

I was wrong about that it does't recognize it . But still is there anyway to know what the datatype of a column in Live Connections? 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

ShmuelM Only in the source model. In Live Connection, Power BI just becomes the front end visualization tool, all the modeling/changes to datatypes, etc would have to happen in the back end, so Power BI doesn't display it other than the sigma symbol to identify numbers.