Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi aarikc17,


Can you ensure you date format is suitable for your system setting?(for instance: uk date and us date) If not, you can convert it before change type to date.

 

I also test to change type without any issue.

 

Regards,

Xiaoxin Sheng

  • aarikc17's avatar
    aarikc17
    Icon for Advocate I rankAdvocate I
    9 years ago

    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.

    • aarikc17's avatar
      aarikc17
      Icon for Advocate I rankAdvocate I
      9 years ago

      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......