Forum Discussion
Support for ISO 8601 Date Time format DateTime.ToString("O") unfortunately missing
ericleigh007,
After I enter the key, I am able to directly change the data type of the columns to Date/Time. I am using the latest version of Power BI Desktop(2.52.4921.682 ). In your scenario, please first convert the data type of these columns to Date/Time in Query Editor as described in my first reply, click "Close & Apply" , then you will be able to create calculate column in Data View as shown in the following screenshot.
Regards,
LydiaSo thanks, Lydia,
This is not really a solution. This is a workaround using the query editor, and it works very well.
but the DAX level offers "Modeling" change type, which doesn't work.
Obviously, if the query editor can do this, the Modeling tab should also be able to. In fact, if the Modeling logic in the load worked like query editor, it would have automatically recognized the field as date/time, like other services do.
Thsi is not a matter of "can I do it", it is a matter of "does the tool work as expected"? In this case, I can do it, but the workaround should not be necessary. I changed the title to be more clear about that.
Please submit a bug to the team indicating that the Modeling tab at the DAX level should work properly here.
-thanks very much for you help.
-e
ericleigh007,
It requires to enter credential when I open query editor of your PBIX file. How about you add a custom column as my previous reply?
And as your post, when I copy the above date values to new table and import them to Power BI, they are automatically changed to date/time data type.
Regards,
Lydia
Sent you a direct message containing the CosmosDB read-only key.
-e
ericleigh007,
After I enter the key, I am able to directly change the data type of the columns to Date/Time. I am using the latest version of Power BI Desktop(2.52.4921.682 ). In your scenario, please first convert the data type of these columns to Date/Time in Query Editor as described in my first reply, click "Close & Apply" , then you will be able to create calculate column in Data View as shown in the following screenshot.
Regards,
LydiaSo thanks, Lydia,
This is not really a solution. This is a workaround using the query editor, and it works very well.
but the DAX level offers "Modeling" change type, which doesn't work.
Obviously, if the query editor can do this, the Modeling tab should also be able to. In fact, if the Modeling logic in the load worked like query editor, it would have automatically recognized the field as date/time, like other services do.
Thsi is not a matter of "can I do it", it is a matter of "does the tool work as expected"? In this case, I can do it, but the workaround should not be necessary. I changed the title to be more clear about that.
Please submit a bug to the team indicating that the Modeling tab at the DAX level should work properly here.
-thanks very much for you help.
-e