Forum Discussion
Quickbooks
Is there a Power BI specific tutorial anywhere for this? I did all the thing son the QB end, and I can access QB data via Excel, but attempting to get at the data in POwer BI always leads to an error even though I can see all the tables. Very painful to be so close and yet so far.
I am using Quickbooks Enterprise 2017.
best,
Jesse
http://qodbc.com/support.htm
I would first confirm that you don;t have a mismatch between 32 bit and 64 bit. In the example I see you are using a 64 bit driver. Are you running a 64 bit powerbi?
Thank you for the reply. I filled out a support request with QODBC, the compnay that makes the driver for QB. It looks like its NOT able to work with Power BI, and perhaps the company hardcodes in any compatiable third party apps. I am including their reply below in case other folks were as frustrated as I.
Hi Jesse,
I would like to inform you that QODBC is not supported to the Power BI desktop. Normally we suggest using MS Access as middleware in QODBC unsupporting application. But in this case, middleware also not working because Power BI is not able to fetch MS Access linked table.
Please refer:
http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2584/45/how-to-use-ms-access-as-middleware-with-qodbc
You can dump QuickBooks data in MS Access.
Import the source data into a new table in the current database, this option will directly extract tables into Access Database, you can view and edit these tables but all modification will not be uploaded unless you build another query to do so.
Please refer:
http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2771I just created a new video that show's how you can use the gateway to connect QuickBooks data stored in the QQUBE database. Find the video at: https://youtu.be/X5w0itYzYtI
Ernest