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.
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
Already I have developed report by creating bridge table for id columns for 2 tables inside excel for yesterday which utilizes yesterday data but today when I refresh I see the power bi report has only today's data so how do I retrieve yesterday data in this scenario. Please let me know if you understood though I only maintain datsource fresh data on daily basis in consolidated SharePoint document library so watever report I created is from different folder which is daily folder in consolidated document library so my power bi is scheduled report from daily folder in the document library but then everyday I upload file with same structure and yesterday data is not present in this datsource SharePoint daily folder so my question is everyday historical data gets lost. Though I need help I'm maintaining everyday excel file in consolidated library and again I should apply bridge table to filter required tables after combining and then refresh going forward kindly advise
Power BI has no memory. Don't overwrite the data on the SharePoint. Add new files daily and then ingest by combining them.
Ok 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
If 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