Forum Discussion
Formatting SSAS values (Live connection/explore live)
I want to see my date as Date and not as DateTime.
The data comes from a cube - SSAS. If I use excel, the date shows as it should. But when I get the data for a PBI report and I start connecting data from the desktop - using PCG, I will get the datetime and not the date.
It is not possible to format because I do not have the buttons to go back the system (like to do DAX) and stuff. Somebody there with the same kind of issue? Help Please. (Live connection)
/The Martha
Hi TheMartha,
Currently, Cell level Formatting and translation features are not supported in this release of SSAS MD. These features will be enabled in upcoming releases of Power BI Desktop. Even you use FORMAT() function, it will still take the source format.
See "Limitations of SSAS Multidimensional Models in Power BI Desktop" in link below:
Connect to SSAS Multidimensional Models in Power BI Desktop
Regards,
6 Replies
Hi TheMartha,
Currently, Cell level Formatting and translation features are not supported in this release of SSAS MD. These features will be enabled in upcoming releases of Power BI Desktop. Even you use FORMAT() function, it will still take the source format.
See "Limitations of SSAS Multidimensional Models in Power BI Desktop" in link below:
Connect to SSAS Multidimensional Models in Power BI Desktop
Regards,
Anonymous Status on the request still shows "Under Review" from June...
Still, The DateTime is not showing in the table for SSAS live connection with Power BI.
When I export the data into excel DateTime format is coming.
