Forum Discussion

DanCasSan's avatar
DanCasSan
Icon for Helper V rankHelper V
6 years ago

HANA connection upgrade issues

Hello, I have an import mode connection to a table in Hana with approximately 4.6 million records, the estimated import time is 4-5 hours.   The problem occurs when I want to update my dataset for ...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
DanCasSan's avatar
DanCasSan
Icon for Helper V rankHelper V
6 years ago

Hi @mwegener,


I have tried to do it with incremental update; however, I get the same message that I put at the beginning. I did the test with 100K records and from the desktop application it takes 15 minutes to load. Why could I be getting the same error message or is it that PBI does not support incremental loading for Hana?

Again, I am grateful for your support

Regards,

Daniel Castillo

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hi DanCasSan ,

 

to the best of my knowledge, HANA also supports the incremental refresh.

But the first import with incremental refresh imports the entire configured period. Maybe that's still too much data.

 

  • DanCasSan's avatar
    DanCasSan
    Icon for Helper V rankHelper V
    6 years ago

    Hi @mwegener.

    The total data to load for that period is 100,000 records. Loading on the desktop takes about 15 minutes. Do you think there is another reason?

    Thnx & regards

    Daniel Castillo

    • mwegener's avatar
      mwegener
      Icon for Most Valuable Professional rankMost Valuable Professional
      6 years ago

      Hi DanCasSan ,

       

      can you share a screenshot of the incremental refresh setup?