Hi Team,

I have data uploading from my finance data base via API - Odata. I have selected certain period in finance data base for uploading and my 3 years data cannot be seen as overwhelming. However whenever I refreshed the data in power BI then power query, it took at least 20 mins to refresh my model with about 5 data tables.

In my query, I have merge queries.

Please let me know what can I do to improve the time taken. Sometimes table.buffer is working. But I do not know at which step I should add table.buffer. If you have other method, can you please share me.

Thank you.

Regards,

Aye