QuickBooks Online Beta Connector Error

[hyndmanevanp]

I setup the my QBO connector using the beta connector over a year ago.  Upon refreshing today, I received "OBDC: ERROR [HY000] [Microsoft][Quickbooks] (62) API Connection Failed. Forbidden Request.  HTTP Response code 401"

I get the same error when I open Get data and try the connector.  If it matters, this is my first refresh attempt since updating to  Version 2.132.1053.0

Thank you

[Anonymous]

Thanks for the reply from rajendraongole1.

Hi @hyndmanevanp ,

It seems that you have gotten a solution. Could you please mark your reply as solution? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you for your contribution!

Best Regards,
Zhu

[rajendraongole1]

Hi @hyndmanevanp -  Can you check on access tokens for API connections can expire. You may need to re-authenticate your QBO connection to obtain a new token.Intuit (the provider of QuickBooks) may change their API, which might require changes to your connector setup. Check QuickBooks’ developer resources for any recent changes to the API.

resolved threads FYR:

Solved: QuickBooks to Power BI - Microsoft Fabric Community

Power Query QuickBooks Online connector - Power Query | Microsoft Learn

sometimes, Intuit may change their API, which might require changes to your connector setup. Check QuickBooks’ developer resources for any recent changes to the API.

Quickbooks Online Connector for Power BI (intuit.com)

Connect QuickBooks Online to Power BI (vidi-corp.com)

Hope the above information helps

[hyndmanevanp · Accepted solution]

I contacted support, the solution was to open the data source settings, clear the QB permissions, the edit them and retype username and password.  I have to do this everytime I update.

Thanks.