Forum Discussion

eddd83's avatar
eddd83
Icon for Resolver I rankResolver I
6 years ago
Solved

Direct query - Remove time for date column

I am doing a direct query and in my SQL query, i'm converting a column to a date using convert(date, COLUMN). However, the data is imported into powerBI as "3/9/2020 12:00:00 AM". Since I am using a ...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi eddd83 

    yes, just pick the column, go to the Modeling (or Column tools) ribbon and select date format as you wish

     

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi eddd83 

yes, just pick the column, go to the Modeling (or Column tools) ribbon and select date format as you wish

 

eddd83's avatar
eddd83
Icon for Resolver I rankResolver I
6 years ago

az38 What you suggested doesn't work because In the modelling tab, it says "This table uses DirectQuery and cannot be shown"

 

  • eddd83's avatar
    eddd83
    Icon for Resolver I rankResolver I
    6 years ago

    az38 Nevermind. I see what you meant and I figured it out

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I ran into same problem. Can you please share your solution?