I have an O Data feed pulling timesheet data from Project Online. I have 2 issues with this:
At present, the table takes 4-6 minutes to load but it is a relatively new data set, so as it grows, I'm concerned refresh time will grow as well.
If you could try to use Incremental refresh in Power BI.
Hi @v-lili6-msft ,
Thanks for your advice, but if I understand this correctly, it is only available to premium customers and we only have pro licenses, so this isn't a solution for us.
it is only available to premium customers for now, and soon it will be available to pro customers.
Please see that
Amanda Cofsky (Program Manager, Microsoft Power BI) responded · Apr 25, 2019
Thanks for all the feedback on this! We are definitely planning on adding Incremental refresh to Pro. Do know though that it is a fair amount of work, so it may be a bit before we can give you a more firm timeline.
Thanks Lin @v-lili6-msft ,
I am going to leave the query open for longer as while this is an ideal solution, until it is released, it won't resolve our problem. I will keep an eye out for that release though - it is good news.