Forum Discussion
null date from SSAS cube shows default date 12/30/1899
I have a MS SSAS cube that's the source of my report, so I can't modify the data in any way. I have a table that displays a mix of dim and fact data on the report/dashboard. Where the dates are null, it is displaying 12/30/1899. Is there any way I can get it to just display blank? I am not using the fields with the potential for null dates in a slicer or on a chart, just in the table.
thanks!
It may have something to do with the compatibility level. Power BI is essentially a local instance of SSAS tabular with compatibility level 1200. Not sure where you would go from here, but without the option to use the query editor, DAX or MDX, I don't know what to tell you. I would open a support ticket if possible
9 Replies
- dkay84_PowerBI
Microsoft Employee
You can still use the query editor to transform your data, so I would try replacing the values there. It sounds like the "nulls" are not registering as actual nulls, as that date corresponds to a numeric value of 0 being converted to a date data type. You could also try adding a column with DAX that checks if the value is 0 return BLANK() otherwise give the date.
My query editor menu is greyed out except for Data Source Settings, but that just gives me the servername and Database Name. My data source is a SQL Server Analysis Services database using an Enterprise gateway; I can view the data in cube or through SSMS and the data in the field is null. It seems something that Power BI interface is doing, maybe to make it slicer friendly?
If there's a way to edit the data, I would be ok with that because that would help a different problem I have with the report.
- dkay84_PowerBI
I'm not sure why you can't access the query editor. Can you right click on the fields list and add a column?
