Power bi report

HI bzeeblitz ,

Please upload all the files to a SharePoint folder and use the SharePoint Folder connector in Power BI.

1. When you enter the folder path, a preview of your data will appear.
   
2. Click Combine & Transform (ensure all files have the same structure).
3. Power BI will automatically merge data from all files into a single table.
4. In the next window, choose a sample file to define the structure.
   
5. Click OK, and Power BI will consolidate data from all dates.

Let me know if you need any further clarification! 🚀

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

Let's Connect on LinkedIn: https://www.linkedin.com/in/anmol-malviya/?originalSubdomain=in

Subscribe my youtube channel for Microsoft Fabric and Power BI updates: https://www.youtube.com/@AnmolPowerBICorner

Power BI has no memory. Don't overwrite the data on the SharePoint. Add new files daily and then ingest by combining them.