Forum Discussion

Baskar's avatar
Baskar
Resident Rockstar
10 years ago
Solved

Issue in Use first row as header

Hi Guys,

 

am facing prob on while use my first row as header,

My first row is date, pls see the attachment snap

2. After use first row as header 

 

 

 

i want to know where is my first row date ? where it is gone ?

 

ankitpatira Greg_Deckler Anonymous

  • This row has gone forever, because PBI doesn't accept date as a column header.

    Instead format your columns as text, promote header and then format back to decimals.

2 Replies

  • ImkeF's avatar
    ImkeF
    Community Champion

    This row has gone forever, because PBI doesn't accept date as a column header.

    Instead format your columns as text, promote header and then format back to decimals.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Table.PromoteHeaders(#"Previous Step",[PromoteAllScalars=true])