Convert DateTime to Table missing

[Tallyski]

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? 

[PBILearner2022]

I am also facing the same issue, can anyone help on this please 

[Jihwan_Kim]

Hi,

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

[Jihwan_Kim · Accepted solution]

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.

[cchen75]

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

[Tallyski]

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

[uzuntasgokberk]

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]

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