Forum Discussion
Power bi report
HI bzeeblitz ,
Please upload all the files to a SharePoint folder and use the SharePoint Folder connector in Power BI.
- When you enter the folder path, a preview of your data will appear.
- Click Combine & Transform (ensure all files have the same structure).
- Power BI will automatically merge data from all files into a single table.
- In the next window, choose a sample file to define the structure.
- 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
- When you enter the folder path, a preview of your data will appear.
Power BI has no memory. Don't overwrite the data on the SharePoint. Add new files daily and then ingest by combining them.
Please don't use .xls - it is a legacy format. Use .xlsx if possible.
Have you considered storing these files in a SharePoint rather than in Teams?
Yes it's xlsx .ok we store in SharePoint as per your suggestion but how to extract historical data in power bi report let's say
Report 01.01.25 xlsx
Report 01.02.25.xlsx ..... So on daily basis from specified path in SharePoint document library. As of now we are able to generate today xlsx file that is one xlsx file but we need to perform for historical data.kindly suggest
