Forum Discussion
newpbiuser01
Helper V
Helper VData Refresh Times and Duplicate/Referenced Tables
Hello, I have a question around referencing vs. duplicating data tables. I am working with large data tables (>20 million rows) and in order to increase the efficiency of the reports, I break dow...
20M rows is not considered large (unless you have gazillions of columns)
Consider using Table.Buffer if you keep re-using a source table in your query. (Doesn't help across queries)
Use Query Diagnostics to know for sure where your mashup is spending its time, or use the SQL Profiler option
lbendlin
Super User
Super User20M rows is not considered large (unless you have gazillions of columns)
Consider using Table.Buffer if you keep re-using a source table in your query. (Doesn't help across queries)
Use Query Diagnostics to know for sure where your mashup is spending its time, or use the SQL Profiler option