[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?
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 220.127.116.113 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.
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: