Issue in Use first row as header

[Baskar]

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 @Seth_C_Bauer

[Anonymous]

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

[ImkeF · Accepted solution]

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.