Forum Discussion
current_thing
3 years agoFrequent Visitor
Prevent PowerBI from refreshing an imported table
I have a PowerBI file that has two imported files: table1.csv (approx 18m rows) table2.csv (approx 7m rows) I then have another table, table3, where I combine the two tables: =table.combine({...
Anonymous
3 years agoNot applicable
Sorry, I'm currently viewing this on my mobile phone, so don't have access to Power BI to confirm. However, I want to say that you can right click on the table 1 query in "Transform Data" and disable it from the report refresh. But I suspect that might also remove the days from your report. I will need to check that tomorrow.
The second option I am thinking of is to set an incremental refresh on Table 1. If the table is static, then it won't incrementally refresh.
I hope that helps.