Getting Multiple header while loading data from Multiple CSV files (from Sharepoint)

[Kishan_Gupta]

While I'm trying to load data from multiple csv files from a sharepoint location, I'm getting multiple rows for header also, due to which further action fails :S

I cant use remove duplicates as it will remove records from data too.

How should I resolve this

[rubayatyasmin]

Hi, @Kishan_Gupta 

* Use the first row as header from the PQ home/transform tab

* Remove the first row

this should solve the problem. 

[Kishan_Gupta]

As the data will be refreshed daily and daily one new file will be appended, so the above solution won't work as a premanent fix.

[Mahesh0016]

@Kishan_Gupta Please can you elaborate on how to load data from multiple CSV files from a SharePoint location? Thank You!

[Kishan_Gupta]

Similarly we can add csv files as well (in filter using .csv)
https://powerbi.microsoft.com/fr-ca/blog/combining-excel-files-hosted-on-a-sharepoint-folder/