Forum Discussion

Pucca121's avatar
Pucca121
Helper II
9 years ago
Solved

Query changes

Hello !   I would like to change the hour in the query. How can I do it?   Thank you :)      
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi Pucca121,

     

    Select 'Edit Queries' from arrow down.

     

    Open your power query code via clicking on 'Advanced Editor'

     

    In your code, you just need to add the highlighted part. You should replace the #"Changed Type" and "Date" with your own scenario.

     

    Regards,
    Yuliana Gu

  • Pucca121's avatar
    Pucca121
    9 years ago

    MarcelBeug

     

    It worked. I will see if my problem is resolved :)

    Thank you sooo much!

     

    P.

MarcelBeug's avatar
MarcelBeug
Community Champion
9 years ago

Also notice that the identifier after "in" must be the last step name before "in".

Pucca121's avatar
Pucca121
Helper II
9 years ago

 

 Hello!

MarcelBeugv-yulgu-msft

 

I made the changes and it returned me this error. Any ideas why?

Thank you very much

 

P.

 

  • MarcelBeug's avatar
    MarcelBeug
    Community Champion
    9 years ago

    Apparently you either overlooked or misunderstood my previous post.

    Just change the identifier after "in" to #"Renamed Columns".

  • Pucca121's avatar
    Pucca121
    Helper II
    9 years ago

     

    MarcelBeug

     I modified like this and it returned me this error -.....-

    Thank you so much for your time!

  • MarcelBeug's avatar
    MarcelBeug
    Community Champion
    9 years ago

    In the last step you use function Table.RenameColumns. This should be Table.TransformColumns.

  • Pucca121's avatar
    Pucca121
    Helper II
    9 years ago

    MarcelBeug

     

    It worked. I will see if my problem is resolved :)

    Thank you sooo much!

     

    P.