Forum Discussion
Need Assistance with Power BI query that pulls Quickbooks data, which has stopped working
This is for a Microsoft Power BI report that has been pulling in Quickbooks data for > 3 years. Queries started failing around 8/9. I'm looking for assistance diagnosing a 429 error that is thrown as soon as I click a Quickbooks Table from the PBI query. Posted message on Intuit site and was told, "We are aware of the issue and Microsoft Power BI team is working with us on this.Kindly reach out to the Microsoft Power BI team for further updates regarding this issue." but I don't see any known issues. Anyone encounter this and is there a workaround or is it truly a known issue?
Hi jasonhuebner,
Thank you Shahid12523 for the response.
There is already an active suggestion in the Ideas forum that outlines the need for an official, supported QuickBooks integration. I recommend you to please upvote that idea, add your use case and comment on that existing forum post. Feedback submitted through these channels is frequently reviewed by the product teams and can contribute to meaningful improvements.
Request to Keep/Restore QuickBooks Power BI Connec... - Microsoft Fabric Community
Thanks and regards,
Anjan Kumar Chippa
5 Replies
- rajendraongole1
Super User
Hi jasonhuebner - can you please refer the below solved and learn web. For more details.
https://community.fabric.microsoft.com/t5/Service/Power-BI-to-Quickbooks-Online-Error/m-p/4793426
Learn
https://learn.microsoft.com/en-us/power-query/connectors/quickbooks-online
https://qbtoolhub.com/quickbooks-error-429/
Hope the above links helps.
v-achippaCommunity Support
Hi jasonhuebner,
Thank you for reaching out to Microsoft Fabric Community.
Thank you rajendraongole1 for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user for the issue worked? or let us know if you need any further assistance.
Thanks and regards,
Anjan Kumar Chippa
Appreciate the response but none of these links is fully relevant. This can't be related to too many requests since the error occurs accessing the table. I can't limit rows returned before the access table step. This link Power Query QuickBooks Online connector - Power Query | Microsoft Learn says it is deprecated, is that really the case, since I still see it as an option in Power BI Desktop? If deprecated is there a new qay to query Quickbooks data?
- Shahid12523
Community Champion
It’s a known issue with the QuickBooks–Power BI connector since Aug 9. The 429 error = rate limit/API issue on Intuit’s side. No fix yet; workarounds are ODBC connectors or exporting data until Microsoft/Intuit resolve it.
- v-achippa
Hi jasonhuebner,
Thank you Shahid12523 for the response.
There is already an active suggestion in the Ideas forum that outlines the need for an official, supported QuickBooks integration. I recommend you to please upvote that idea, add your use case and comment on that existing forum post. Feedback submitted through these channels is frequently reviewed by the product teams and can contribute to meaningful improvements.
Request to Keep/Restore QuickBooks Power BI Connec... - Microsoft Fabric Community
Thanks and regards,
Anjan Kumar Chippa
