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 fir...
Need Help
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

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

    I could not see any image of the table?