Forum Discussion

GarethParry's avatar
GarethParry
Icon for Helper I rankHelper 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
Anonymous's avatar
Anonymous
Not applicable
4 years ago

1. add index column

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