Azure Data Factory Connector for QuickBooks Online | Coursera Community
Answered

Azure Data Factory Connector for QuickBooks Online

  • 19 March 2021
  • 1 reply
  • 28 views

Badge +2

Hi everyone!!

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:

Connection failed
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.

 

icon

Best answer by Jose A 22 March 2021, 18:02

Hi @walkershashi, you may need to look in your course’s discussion forums since there will be more people that may know how to help you with this. 

You can check out this article that explains how to find and use your course discussion forums. Good luck!

View original

1 reply

Userlevel 7

Hi @walkershashi, you may need to look in your course’s discussion forums since there will be more people that may know how to help you with this. 

You can check out this article that explains how to find and use your course discussion forums. Good luck!

Reply