Convert DateTime to Table is Missing

[cchen75]

I am trying to create a date table in Power Query. I create this by opening a blank query then use DateTime.LocalNow( ) and normally, there is an option to convert to table but it is not showing up for me now. Is it missing? 

[v-prasare]

@cchen75 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided our super users worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

@cchen75, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided our super users worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

@cchen75  As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

@Mubar, @SundarRaj, @OwenAuger, Thanks for your promt response here

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[Mubar · Accepted solution]

Hi @cchen75 

This is a Power Query issue I've noticed lately, you can convert it to a list by doing so in your M code. then right-click and convert to a table.

= {DateTime.LocalNow()}

If you find this helpful, kindly mark my response as a solution.

Thanks, Happy Building

Mubar

[SundarRaj]

Hi @cchen75 , ideally it should be available. Since, it isn't you can use the manual M code to get into a Table format. I'll share a snippet below. Thanks

[OwenAuger]

Hi @cchen75 

This looks to be another glitch in the Power query interface associated with dark/light mode settings.

Try switching back to Legacy as described here.

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-dark-mode

Does that fix it?

I suggest placing some feedback using the link in the options menu. I've placed some already relating to other glitches!