Forum Discussion
po
Post Prodigy
Post ProdigyIncremental 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...
GilbertQ
Super User
Super UserHi 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?
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?
poPost Prodigy
Post ProdigyHi,
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
- GilbertQHi there
I could not see any image of the table?