Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
2 notes to mention
1. I noticed a bug when running the query for Invoice_Sales_Item_Line. Please see the error report
DataSource.Error: ODBC: ERROR [HY000] [Microsoft][DSI] (20030) Memory management error.
Details:
DataSourceKind=QuickBooksOnline
DataSourcePath=QuickBooksOnline
OdbcErrors=[Table]
2. QuickBooks Online hides many accounts when they are "deleted" (really they are jsut removed from view), but for analytics purposes we sometimes need them for past data references. In their API, there is a T/F column for this called "Inactive". In your integration, there currently is no option to pull a list of these inactive accounts. I beleive this needs to be specified when calling their API (either calling just inactive or both).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.