Forum Discussion
amir_mm
Helper III
2 years agoIncremental refresh - Table keeps loading in PBI desktop
Hello, I defined new parameters on a date/time column in one of the tables (RangeStart and RangeEnd), and filtered the column to a custom date range, but when loading into PBI desktop the table k...
smpa01
Community Champion
2 years agoamir_mm when you say 10M rows, that probably means it is coming from some sort database. What if you write native db queries instead of fetching the data from db using PQ ? In my case, I regularly query large data tables but always use native db query (e.g. SQL). I find no advantage in trying to oblige query folding; it is rather a performance killer, Use the SQL and bake IR on top of that. It is a killer combo.