Forum Discussion
Advocate IILive 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 not show the date hirarchy that PowerBi builds automaticly when It recognize a date column (for example when building a line chart visualsation)
I have 2 main questions:
1. Is there a way I can overcome this issue?
2. Is there a way to know what datatype PowerBi "see" when connecting live to analysis services ?
Thanks!
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?
3 Replies
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?
ShmuelMAnonymous 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?
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.