Forum Discussion

Tallyski's avatar
Tallyski
Advocate I
1 year ago
Solved

Convert DateTime to Table missing

To build a date table, I used to use datetime.localnow() in a blank query and then convert it to a table. The convert to table is now missing. How have they changed it? 

 

  • Hi,

    I think this is not the expected behavior in dark mode.

    I tested in the dark mode, and I saw the same thing as what you described.

    Please try to change it to not-dark mode, and then you will see something like below.

     

     

     

     

7 Replies

  • Hi,

    I think this is not the expected behavior in dark mode.

    I tested in the dark mode, and I saw the same thing as what you described.

    Please try to change it to not-dark mode, and then you will see something like below.

     

     

     

     

    • Tallyski's avatar
      Tallyski
      Advocate I

      Thank you. It was the dark mode issue you mentioned. Very much appreciated.

    • cchen75's avatar
      cchen75
      Frequent Visitor

      I am not in dark mode and am experiencing the same issue. Any tips?

  • Hello Tallyski,

     

    You might be unchecked enable load? You can check with right click on the date table.

    Kind Regards,
    Gökberk Uzuntaş

    📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

    🔗 Stay Connected:
    📘 Medium |
    📺 YouTube |
    💼 LinkedIn |
    📷 Instagram |
    🐦 X |
    👽 Reddit |
    🌐 Website |
    🎵 TikTok |

    • Tallyski's avatar
      Tallyski
      Advocate I

      No, it's not that. When I created the query, no datetime transform box appeared for me to select convert.

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Super User

      Hi,

      I think, if you right-click the column name in the query in Power Query Editor, you can see the functions.
      🤔