Forum Discussion
Date Format Direct Query
I found this........ it worked........
https://community.powerbi.com/t5/Desktop/Unable-to-alter-number-formatting/td-p/38134
With so many others being able to change the data type I will try the above and report back at the end of the day.
dtartaglia I tried selecting and unselecting the "Allow unrestricted measures in DirectQuery" and both did not let me format the data. I am also on the latest version of Power Bi.
Hasan The formatting in on the modeling tab is greyed out and I cannot use that.
Anonymous I am not sure what you mean by my system time setting. This is what my time looks like
I have to be missing something basic if you guys can change the data type in a DirectQuery......
I found this........ it worked........
https://community.powerbi.com/t5/Desktop/Unable-to-alter-number-formatting/td-p/38134
Hi,
Using direct query mode, power query changes may not apply but can work on model.
you can go to the modeling viewand go to the table, click on the column name which need to change the date format, right side in the properties pane you find general, formating, advanced options. In format option you can change the date type and date format.
Hope this will help.
Thanks so much! This is the best no-code solution.
