Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Combing Files/Standardize

Brass Contributor

Hello!  I have a bit of a problem... I have over 30 files that have either one or another format (based on time).

 

I am wanting to standardize the data to input into powerBI.  I have all of these files in on location on a SharePoint site, but need to get them all in the same format to be able to combine them in PowerBI.  I'm not sure what the best way to go about this is.  

 

Attached are two files that are the two different formats (different by a few columns having to do with COVID).

 

Any advice/tips on how to combine this data is MUCH appreciated!  I would really love to not have to manually manipulate each file.

0 Replies