Forum Discussion

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

 

After changing the data type

dtartaglia's avatar
dtartaglia
Icon for Resolver I rankResolver 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi,

       

      Are you trying to import SAP data using import mode? I am assuming you first loaded the data without transforming and still you are not able to see "Data type" in Data modelling tab even after selecting the table and column you would like to change the data type format.  Can you please let us know the error that you are reciveing.Please find the below screenshot

       

      I don't think so we can change from import mode to direct query mode without affecting data after bulding the dashboard. We have to select this option while building the dashboard.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Thanks for replying Aswini!! It's very helpfull.

         

        I got solution for that Date formatting.

         

        But I wanted to know that "Is it impossible to Change import mode to direct query" or Is there any way to do that?

         

        Actually, I built report using import mode, which i didnt notice untill i complete my report. Later, I tried changing to directquery, but i couldn't find any solution for that. 

         

        Thanks 

        Sai