Knowledgebase
[QODBC-Desktop] QuickBooks and Microsoft PowerBI Desktop
Posted by Ricky - QODBC Support on 15 May 2020 07:39 AM

Using Microsoft PowerBI with QuickBooks Data

Problem Description 1:

How to connect to QuickBooks Data with Power BI using QODBC Desktop?

Solutions: 

Open the QODBC setup screen and change the QODBC Compatibility mode from “Default” to “3.8.”

To change, please follow the below steps:

Start >> All Programs >> QODBC Driver for QuickBooks >> Configure QODBC Data Source >>Go To "System DSN" Tab>> select DSN "QuickBooks Data" >> click "Configure”>> Switch to "Advanced" tab>> Navigate to "QODBC Compatibility">> change to "3.8"

 

Start QuickBooks and log in to the QuickBooks company file as QuickBooks user Admin.

Start Microsoft PowerBI Desktop (32-bit).

Navigate to the “Get Data” option, and from the drop-down list, select the option “More.”

 

A popup with the title “Get Data” should appear.

Select "Other" --> "ODBC" and click the "Connect" button

 

Select the “QuickBooks Data” from the Data source name (DSN) list and click the "OK" button.

 

Note: If you are using QODBC version 19.0.0.333 or lower, use the “Advanced options” >> Write the SQL statement for the table you want to fetch data from.

For example, “select * from customer” and click the “OK” button.

 

You should get the preview of the table. Click the “Load” button to continue.

 

 

Select the fields you want to display on the report. This will add the fields to the report and will also display the data.

 

 

If you are facing "Driver does not support this parameter", please switch QODBC, QRemote 32-Bit DSN, and QRemote 64-Bit DSN to ODBC Compatibility 3.8.


To change compatibility in QODBC, follow the below path:
Start >> All Programs >> QODBC Driver for QuickBooks >> Configure QODBC Data Source >>Go to "System DSN" Tab>> select DSN "QuickBooks Data" >> click "Configure”>> Switch to "Advanced" tab>> Navigate to "QODBC Compatibility">> change to "3.8"

If you are using Power BI 64-bit, you need to change for QODBC and QRemote 64-bit clients. To change compatibility in QODBC, follow the below path:
Start >> All Programs >> QODBC Driver for QuickBooks >> Configure QODBC Data Source >>Go to "System DSN" Tab>> select DSN "QuickBooks Data" >> click "Configure”>> Switch to "Advanced" tab>> Navigate to "QODBC Compatibility">> change to "3.8"

To change compatibility in QRemote 32-bit, follow the below path:
Start >> All Programs >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source >>Go to "System DSN" Tab>> select "QuickBooks Data QRemote" DSN >> click "Configure">> Switch to Advanced tab and change 'ODBC Compatibility' to '3.8' and click the Apply/OK button.

To change compatibility in QRemote 64-bit, follow the below path:
Start >> All Programs >> QODBC Driver for use with QuickBooks (64-Bit)>> Configure QODBC Data Source >>Go to "System DSN" Tab>> select "QuickBooks Data 64-bit QRemote" DSN >> click "Configure">> Switch to Advanced tab and change 'ODBC Compatibility' to '3.8' and click the Apply/OK button.

Try connecting again. It should fix the issue you are facing.
If you are using the older version of Power BI, please download the latest and try connecting with QODBC.

(2 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).