Forum Discussion
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...
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