Forum Discussion

Icon for Helper V rank

Helper 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

Tips and Tricks

Icon for Most Valuable Professional rank

Most Valuable Professional

6 years ago

was your problem solved?

DanCasSan
Helper V
6 years ago
Hi mwegener ,

No, I have also tried with few registers and it gives me the same error.

Regards,
Daniel Castillo
- mwegener
  Most Valuable Professional
  6 years ago
  Hi DanCasSan ,
  
  "Data refreshes must complete in less than 2 hours on shared capacity. If your datasets require longer refresh operations, consider moving the dataset onto a Premium capacity. On Premium, the maximum refresh duration is 5 hours."
  
  https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#data-refresh
  - DanCasSan
    Helper 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