CoolP's avatar
CoolP
Regular Visitor
6 years ago
Status:
New

Power Query Online errors out saying "Cannot have leading or trailing blank spaces in a column name"

Power Query Online errors out saying "Cannot have leading or trailing blank spaces in a column name" where as the same query that has columns with leading or trailing whitespaces works fine in the desktop.

 

1 Comment

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support

    CoolP ,

     

    I could not reproduce the issue, in power bi desktop you can also input a blank character as the column header. You need to input characters as column headers.

     

    Regards,

    Jimmy Tao