Can't see columns as date for source SSAS tabluar cube live connection

[salexa]

Hi,

I'm connecting the Power BI report to a tabular cube, live conn, and we have some columns defined as date in the cube but in PPower BI report are shown as text.

Is there a solution to see as date also in Power BI? 

In the cube:

In Power BI:

Thanks,

Irina

[amitchandak · Accepted solution]

@salexa , Can you check if this shows it as text in the column tools or only the symbol is missing. I have doubts about the custom format. is happening with default format too

[Pragati11]

Hi @salexa ,

Is the DATE column in cube in dd/mm/yyyy or some similar format or is it a UNIX Timestamp date or a date value having timezone appended to it like 21/11/2021 UTC ?

It will be nice to have some screesnhot around data values that you see in Cube and in Power BI not just data-type.

Thanks,

Pragati

[amitchandak · Accepted solution]

@salexa , Can you check if this shows it as text in the column tools or only the symbol is missing. I have doubts about the custom format. is happening with default format too

[salexa · Accepted solution]

Hi,

You are right, only the symbol is missing. I've test it with slicer and it has the date options.

Thanks!