Forum Discussion
Combining Multiple excel file with Metrix data in them
Hi All I am trying to figure out the solution for combining multiple excel files available on the sharepoint site, each file has data for a month and I need to import the data into Power Bi for a...
MahyarTF Thank you for your reply, Appreciate it.
The challange I am facing here is, since the files are present in the SharePoint folder and there are many file with monthly data so can not import them individually hence need to combine them before I can apply any transformation on them.
And after combining these files the dates will come as a row in the data set which is getting difficult to split out.