Forum Discussion
Helper IVPower 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.
Helper IVOk so in that case we have more than lakhs of data per single day so is it recommended to use SharePoint for storage or dataverse for storing the same and combining etc
Super UserIf you store the data in a simple format (CSV or Parquet) then the number of rows is not a problem at all. Excel files are suboptimal as they have such a big meta data overhead
- bzeeblitz
I'm asking we are storing combined data at one place that's been extracted and finally consolidated data in SharePoint list right