Forum Discussion

SwiatLudzieTy's avatar
SwiatLudzieTy
Helper 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 slow and after around 4h queries are aborted by the source. Tableau successfully executed the same 10 queries and imported the data under 50 minutes. These were ran on the same machine.

 

What is the reason behind it? Is Tableau data load simply more efficient or am I missing something here? 

 

Thanks, Kamil

Need Help

5 Replies

  • smpa01's avatar
    smpa01
    Community 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
      Helper 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
        Community Champion
        3 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    "It depends"

     

    Can we see your code?

     

    --Nate

    • SwiatLudzieTy's avatar
      SwiatLudzieTy
      Helper I
      3 years ago

      Hello Anonymous, what exactly would you like to see? The code is very simple it's just SQL query as below used in Teradata connector.

       

      select A, B, C, D, E, F
from Table A

       

      Please let me know if there's anything else worth to share. Kamil