Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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!
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |