Forum Discussion
Date type storage in Analysis Services
The documentation says that Date stored as double.
Here is my question:
On which side does the conversion to a readable date occur? On the Analysis Services side or in Power BI?
Where is the double type converts to readable date format?
I sniffed the traffic between Power BI and Analysis Services.
Result is here:
Analysis Services always returns date in format:
<_x005B_MaxOrder_Date_x005D_>2020-03-03T00:00:00</_x005B_MaxOrder_Date_x005D_>
http://books.xmlschemata.org/relaxng/ch19-77049.htmlRegardless of the request, the format is always the same, it is applied on the client side of Power BI.
3 Replies
Hi ruslanen ,
In Power BI Desktop, it is not possible to change data type for columns when you connect to SSAS using "Connect live" mode. You can change data type in SSAS database instead.
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Thank you for your answer.
But that's not what I meant. I need to know in what form Power BI Desktop receives the date value from Analysis Services.
For example:
1231423898142.12312313
or 11-11-2022 03:00
or something else.
I sniffed the traffic between Power BI and Analysis Services.
Result is here:
Analysis Services always returns date in format:
<_x005B_MaxOrder_Date_x005D_>2020-03-03T00:00:00</_x005B_MaxOrder_Date_x005D_>
http://books.xmlschemata.org/relaxng/ch19-77049.htmlRegardless of the request, the format is always the same, it is applied on the client side of Power BI.
