Forum Discussion

po's avatar
po
Post Prodigy
6 years ago

Incremental Refresh - performance

Hi,

 

Have a report in power bi desktop takes max 60 mins to refresh on desktop and have set one of the tables to incremental refresh

 to hopefully refresh more quickly on service.

 

Realise first refresh can take long time but wouldn't expect it to take much longer than this.

 

It is importing from oracle database and can see below at database level.

 

We haven't set any 1000 paging limit - not sure where thsi set and if this slowing it down.  Can it be increased so brings back more rows on each fetch?

 

Concerned will timeout and how can we increase timeout parameter/make sure runs in similar time on first load to what does on desktop?

 

 )

        "$Paged"

WHERE   rownum <= 1000

 

Thanks

Need Help

3 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago
    Hi there

    Can you confirm that it is query folding back to the Oracle database?

    You can do this when the dataset is refreshing to have a look on the Oracle database and see the query that is being requested?

    You can also look in the Power Query Editor, right click on the last step on the table and see if you can go into the Native Query option?
    • po's avatar
      po
      Post Prodigy
      6 years ago

      Hi,

       

      Thanks for reply.

       

      I thought oracle did query flding by default and it prompted you when set up incrementak refresh if query folding woudln't apply?

       

      This is a table which import mode - not sure how to see native query or query folding on database for this.

       

      Thanks