Forum Discussion
Slow Data Refresh through Quickbooks Online API in Power BI
Hi Guys
I am connecting successfully to the old Quickbooks Online Api to have access to the General Ledger Table which is not available through the updated API that you can access through the "Get Data" funtion.
The challenge that I have is that the table refresh takes more than 5 minutes as is and after cleaning it up in Power Query by reducing the column count it loads even longer versus making no changes. It only has 64 000 rows which is nothing compared to what Power BI can handle.
I am thinking that the problem is with Quickbooks and not Power BI. Are there any of you that have experience with the old QBO API and that can point me in the right direction here? Would appreciate it.
Thanks
2 Replies
Hi Ruard ,
Here are some of the more common solutions:
1. Please check whether there existing any step in Power Query consuming too much CPU or memory. And try to use Table.Buffer to improve the data load performance.
2. Use DAX studio/ Performance Analyzer to check out which's the most time-consuming:
Follow this blog to install the dax studio,then connect the opened pbix file in dax studio
https://docs.microsoft.com/en-us/power-bi/desktop-performance-analyzer
3.You can speed Up Data Refresh Performance In Power BI Desktop Using Table.View, refer to this blog.
4.If your dataset is big, the performance will involve many aspects, you could refer to below documents and blogs that may help you:
https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance
http://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques
https://www.sqlbi.com/topics/optimization/
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.v
Hi Ruard ,
Sorry to disturb you...
But did I answer your question ? Please mark my reply as solution. Thank you very much.Best Regards,
Stephen Tao
