ColumnName issue when using Excel from Sharepoint

[GarethParry]

Hi,

I am connecting to a Excel sheet located on sharepoint.

The first row of the sheet has

A1 = ""

B1 = ""

C1 = "Data for June"

D1=""

when it brings in the data intially into power BI the column headings in Power BI are Column1,Column2,Data for June,Column4

How do i set it to not call the 3rd column "Data for June" but Column3 instead?

i think i have to change 

= Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File", Table.ColumnNames(#"Transform File"(#"Sample File")))

but not sure to what

thanks

gareth

[Anonymous]

Hi @GarethParry ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

Best Regards,
Eyelyn Qin

[GarethParry]

Hi,

Thanks for the quick reply. It addes the column headers at a point before i can remove the top row, or add the index column

thanks

Gareth

[Vijay_A_Verma]

In your Transform file code

Go to Transform menu - Use Headers as First Row

Home menu - Remove Rows - Remove Top Rows - Give a value of 1

[Anonymous]

1. add index column

2. replace value if index column=0/1(first row)