Forum Discussion

cchen75's avatar
cchen75
Frequent Visitor
1 year ago
Solved

Convert DateTime to Table is Missing

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? 

  • 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

6 Replies

  • 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

     

  • Mubar's avatar
    Mubar
    Advocate I

    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

  • v-prasare's avatar
    v-prasare
    Community Support

    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?

     

    MubarSundarRajOwenAuger, 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

  • v-prasare's avatar
    v-prasare
    Community Support

    @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's avatar
    v-prasare
    Community Support

    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