Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have a dashboard connected to Azure AS with multiple timestamps columns. However, the date format differs from one to another at times. Could anyone help me to solve this? I would like to have all in date time data type but formatted to "dd-mm-yyyy hh:nn:ss AM/PM". Thanks a lot!
Hi @PBIX123,
That cannot be done by power BI end. You can change it in your data source. Please refer to this blog.
https://www.codeproject.com/Articles/647950/Create-and-Populate-Date-Dimension-for-Data-Wareho
Regards,
Frank
Hi @PBIX123,
Has your issue been solved? If any other question, feel free to let me know please. Also please mark the answer as solution to close the case please. Thanks in advance.
Regards,
Frank
Hi @v-frfei-msft,
sorry for the late reply! Apparently all time elements have the same date format in SQL Server, the same when I do some changes in Power Query. However, the format changes when I display the data in Power BI. Thanks!!
Hi @PBIX123,
Please try to turn the option off and connect to the data source again. However, you need to change the data type later manually.
Regards,
Frank
Hi @v-frfei-msft,
I am afraid the options under "Data Load" tab are not available as the report has a live connection with data model in Azure AS.
Hi @PBIX123,
How did you connect to your datasource? Is that possbile for you to change the data type by this way?
Regards,
Frank
Hi @v-frfei-msft,
It is connected to Azure Analysis Service, so I cannot change the data type from Power BI itself. I tried it in Visual Studio through the Power Query, but I am not sure how to specify the date format from there.
I found M code Date.toText to change the format, but it seems to change the data type to text which is undesireable since the timestamps are used in a number of calculations.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.