Forum Discussion
SwiatLudzieTy
3 years agoHelper I
PBI vs Tableau data load performance
Hello, for my case I need to load 10 quite large tables from Teradata to PBI. I have already reduced PQ transformations to minimum (each query applies Query Folding), but the load is still very s...
smpa01
3 years agoCommunity Champion
SwiatLudzieTy while transporting the tables, can you write sever-side query (Terdadata SQL) rather than simply relying on PQ to do the job. If you do that, it will not oblige Query folding (you will still be fine) but it will transport faster.
SwiatLudzieTy
3 years agoHelper I
Hello smpa01, it is slightly faster indeed, but unfortunately the overall score is still very bad. Good to know this trick though. Thanks! Kamil
- smpa013 years agoCommunity Champion
If the server-side query is fully optimized, you will experience faster load.