The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I have a folder with subfolders generated weekly, named in the format yyyymmdd. Each folder contains CSV files with identical column headers. I’ve imported all of them into a Power BI report using Power Query and refresh it every time a new subfolder is added. However, because there are tens of millions of rows, the refresh takes a long time. Is there a way to refresh only the newly added subfolder while keeping the previous ones untouched, as they remain unchanged?
Thank you for your help,
Stelian
Solved! Go to Solution.
Hi @Stelian ,
According to your statement, I think you want to only refresh specific tables in your report.
Here I have two workarounds to share with you.
1. You can select the table from latest folder and then use "Refresh Preview" in Power Query Editor.
2. You can right click on the tables and turn off "Include in report refresh"in Power Query Editor.
Then Power BI will only refresh the table which is turned on this feature.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you, how can I add the previous ones unrefreshed?
Hi @Stelian ,
According to your statement, I think you want to only refresh specific tables in your report.
Here I have two workarounds to share with you.
1. You can select the table from latest folder and then use "Refresh Preview" in Power Query Editor.
2. You can right click on the tables and turn off "Include in report refresh"in Power Query Editor.
Then Power BI will only refresh the table which is turned on this feature.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
75 | |
70 | |
39 | |
30 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
48 | |
46 |