Forum Discussion

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

Strange error with Date.DayOfWeek function

If I add a column with this function:   = Table.AddColumn(dbo_CMDB_PerformanceData, "WochentagStundeSort", each Date.DayOfWeek([Date], Day.Monday))   the column is displayed correctly in Power ...
Need Help
  • tez's avatar
    tez
    6 years ago

    Hi v-lid-msft ,

    good news: My colleague changed the type from datetime to datetime2 in the MSSQL view. After this both operations worked as expected!

    Regards,

    Thomas

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

v-lid-msft thank you. I use Power BI Desktop Version: 2.80.5803.1061 64-bit (April 2020). I will try your recommendations today or tomorrow and get back to you. If I use a local copy of the table or an Excel file, the error is NOT reproducable, but I will do further testing.

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi tez ,

 

I guess the table is in DirectQuery Mode? so when custom column created, it transform into the native query and return error result. We think you may need to check the query received by the source, if table is in Directquery mode.


Best regards,

 

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

    Hi v-lid-msft ,

    no, I´m in import mode.

    Regards, Thomas.