Knowledgebase: Setup
[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"

 

For QODBC POS, select DSN "QuickBooks POS Data."

For QODBC Online, select DSN "QuickBooks Online Data."

 

 

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 "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.

 

It would be best if you got 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 information and 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"

For QODBC POS, select DSN "QuickBooks POS Data."

For QODBC Online, select DSN "QuickBooks Online Data."

 

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"

For QODBC POS, select DSN "QuickBooks POS Data."

For QODBC Online, select DSN "QuickBooks Online Data."



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.

For QODBC POS, select DSN "QuickBooks POS Data QRemote."

For QODBC Online, select DSN "QuickBooks Online Data QRemote."

 



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.

 

For QODBC POS, select DSN "QuickBooks POS Data 64-Bit QRemote."

For QODBC Online, select DSN "QuickBooks Online 64-Bit Data QRemote."

 



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.

(3 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).