Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 weekend
@3ug3n this post has the answer to your question How you can incrementally refresh any Power BI data source (This example is a CSV File) - FourMoo | ...
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
104 | |
77 | |
68 | |
61 |
User | Count |
---|---|
144 | |
106 | |
106 | |
82 | |
70 |