Solved: Use the [PromoteAllScalars=true] Option

Baskar · ‎08-19-2016

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 ?

ImkeF · ‎08-19-2016

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.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

Anonymous · ‎10-04-2019

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

ImkeF · ‎08-19-2016

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.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

Issue in Use first row as header