Issues with connecting data from Sharepoint

[Anonymous]

Background:

I have a sharepoint folder with excel files for every single day for the past year. The format is slightly off for about 90 days/files. My A column needs to be removed and my b column needs to have the date in a different format for these specificed 90 files/days. Once I do this, all files will have the same format for easy data flow. 

Once I do this, I would like to either...

A. combine all excel files into one so I can feed my Power BI report,

or

B. adjust format on all 90 excel files so they flow with the rest of the excel files within my sharepoint folder into BI.

Any suggestions are much appreciated.

Looking for any and all suggestions. Thanks so much!

[v-kelly-msft · Accepted solution]

Hi  @Anonymous ,

In my opinion,for choice A,it would be much easier for data transformation once all the data is loaded into Power BI.

For choice B,I'm not sure whether it would cause some problems once you do the transformations before loading into Power BI.

So I think A should be a best choice for you.

Check the reference below:

https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!