Forum Discussion

Veritas's avatar
Veritas
New Member
9 years ago

Quickbooks

I want to develope a dashboard of financial statement data pulled from Quickbooks desktop.  What is the best way to pull in the data?  I would welcome guidance from any other users who have developed...
Need Help
MarissaGO's avatar
MarissaGO
Regular Visitor
8 years ago

Hi BetterIdeaGroup,

 

I am using QQube to pull in the Quickbooks data into Power BI. I sync'd the data without error, but now when I open the Power BI Example "financial_pandl_actual-budget-forecast_(qqube6.x).pbix", I get the following errors. I am pulling data from Quickbooks Desktop Pro 2018. Any help is appreciated!

 

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E

Load was cancelled by an error in loading previous table

 

Thank you!

  • BetterIdeaGroup's avatar
    BetterIdeaGroup
    Helper II
    8 years ago

    Hi MarissaGO,
    First let me clarify the architecture. QQUBE extracts QuickBooks desktop information and stores it in a SQL Anywhere database. That database is what is used by PowerBI (and other ODBC compliant tools. With the information available it's hard to tell which of the 3 areas are problematic:


    1. Environmental - i.e. You exact configuration of hardware / software is giving you trouble. For example the memory or CPU size of your computer could be "giving up". Can you access the same data on another computer without issue?

    2. Data related - In some situations data can cause issues. - redoing the query with a sample data file usually roots out this issue

    3. A software logic issue. Because of the various pieces of software involved in this solution, once you have ruled out the other 2 area's, the goal would be to sort out which product is having an issue; So to test for a Powerbi issue you would want to know if some other ODBC based data source of comparable size can be extracted on your version. Similarly, for a QQUBE issue, isolate just the QQUBE database by verifying that you can access the same data from the QQUBE Excel templates?

    I apologize if all this seems complicated but since these topics live on the forum for awhile I wanted to give others tools for figuring out what might be preventing them from getting the information they need to run their business, If you would like to get some direct help can you book an appointment on:
    https://calendly.com/ernestcook

    Ernest