User Profile
3ug3n
Regular Visitor
Joined 3 years ago
User Widgets
Contributions
Power BI file optimisation based on many csv/xls daily exports
Hello everyone, I'm contacting the group because after many research I can't find any satisfactory answer - with any certainty. I have a Power BI file based on merging and analysing around 20 local folders containing CSVs and XLS files produced/gathered on a daily basis (~3000). As can be expected, it takes a very long time to refresh the daily reports. What do you recommend I do to optimise this - knowing that i cannot merge those files upstreams ? Is there a way to create a table (internal or linked somewhere) to store the merged CSVs and then to: - update it incrementally (even if it eventually bloats) - do the ~30 daily analysis queries from it without having to recompile/filter/transform everything every time ? Thank you very much in advance for your suggestions and possible links that detail/explain them ! Have a nice weekend413Views0likes1Comment
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.