Forum Discussion

dtartaglia's avatar
dtartaglia
Resolver I
9 years ago

If I'm in directQuery mode, open the Query Editor I'm able to change a column Data Type from Date/Time to Date.

  • aarikc17's avatar
    aarikc17
    Advocate I
    9 years ago

     

    After changing the data type

    • dtartaglia's avatar
      dtartaglia
      Resolver I
      9 years ago

      I initially had: "Allow unrestricted measures in DirectQuery" enabled. I disabled it and changing the format worked. I wonder if the setting didn't really change? If you click File->Options and settings->Options->DirectQuery and enable: "Allow unrestricted measures in DirectQuery", can you change the format? My test source is a SQL view.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi,

        I am using recent version. i can find only one option "Treat SAP like relational database".

        I enabled it. 

        Even i didnt get chance to edit it. My column is in text format , i wanted it to be date formate witout time in it. please help me with this.

         

        One More help. How to change from import mode to direct query mode without affecting data?

         

        Thanks 

        Sai

    • Hasan's avatar
      Hasan
      Resolver I
      9 years ago

      you might want to sue the modeling option in home page. I jsut tried and it is working for me

      • dtartaglia's avatar
        dtartaglia
        Resolver I
        9 years ago

        aarikc17 are you on the lastest version of BI Desktop?