Forum Discussion

min-E's avatar
min-E
Icon for Helper I rankHelper I
3 years ago
Solved

DirectQuery SQL Convert datetime to date

Using DirectQuery to pull a SQL query The format of the date column is datetime '2023-01-01 00:00:00.000'   In SQL if I use the CONVERT below, I get the results wanted: SQL:  convert (date, (date...
Need Help
Alex_Sawdo's avatar
Alex_Sawdo
Icon for Resolver II rankResolver II
3 years ago

Have you tried to change the data type from Date/Time to Date in Power Query? You can do this by selecting the column and changing the data type in the transform tab. 

min-E's avatar
min-E
Icon for Helper I rankHelper I
3 years ago

Hello,

Indeed I have. It displays the message 'This step is not supported in DirectQuery mode. Switch to import.'

 

  • Alex_Sawdo's avatar
    Alex_Sawdo
    Icon for Resolver II rankResolver II
    3 years ago

    Another question, are you connecting to a table/view or are you using a stored procedure/sql command directly in Power BI? This can only be done if you are connecting to an actual structure and not using a sp or sql command within Power BI. 

    • min-E's avatar
      min-E
      Icon for Helper I rankHelper I
      2 years ago

      I am using a sp. Tested on an existing table and the outcome was what I needed.