Azure Data Factory connector for QuickBooks Online is failing after some regular intervals.
The most probable reason, I can think is because of the QB connector is in preview mode. The connector requires client id, client secret and a refresh token for successful connection.
I have copied and pasted it for the connection so there in no error in the credentials. But this issues get resolved when we create a new app on the intuit developer portal and then feeding in the new credentials, which again fails after certain interval following the same cycle.
The error message returned is:
ERROR [HY000] [Microsoft][QuickBooks] (61) API Connection Failed. Bad Request. HTTP Response code: 400 ERROR [HY000] [Microsoft][QuickBooks] (61) API Connection Failed. Bad Request. HTTP Response code: 400
Is there any way we can integrate the QuickBooks Online data to Power BI. I am currently using data factory to import data from QBO to SQL database and then connecting Power BI.
If there is any other way, please feel free to suggest that.