Forum Discussion

GarethParry's avatar
GarethParry
Helper I
4 years ago

ColumnName issue when using Excel from Sharepoint

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...
Need Help
GarethParry's avatar
GarethParry
Helper I
4 years ago

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