Forum Discussion

SwiatLudzieTy's avatar
SwiatLudzieTy
Icon for Helper I rankHelper I
3 years ago

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...
Need Help
smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
3 years ago

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's avatar
    SwiatLudzieTy
    Icon for Helper I rankHelper I
    3 years ago

    Hello smpa01, it is slightly faster indeed, but unfortunately the overall score is still very bad. Good to know this trick though. Thanks! Kamil

    • smpa01's avatar
      smpa01
      Icon for Community Champion rankCommunity Champion
      3 years ago

      If the server-side query is fully optimized, you will experience faster load.