Connecting to Quickbooks Enterprise Desktop

[jessewysong]

Hello folks,

I spent aorund 5 hours yesterday trying to get Power BI to connect to out Quickbooks Enterprise 2017 company file. 

I have created the ODBC in QB, successfully tested the connection in QB, and accessed tables via Get Data/Other Sources/Microsoft Query in Excel.

However, when I try in Power BI via the Other/ODBC option...

• I have QB Data 64bit QRemote available via the pull down menu.
• In the Navigator window I can see all the tables
• But clicking on any table to view the fields casues an error

DataSource.Error: ODBC: ERROR [HYC00] [Microsoft][ODBC Driver Manager] Driver does not support this parameter
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=QuickBooks Data 64-Bit QRemote
OdbcErrors=Table

I feel like I am so close, and yet so far. If anyone has success connecting Power BI to QB Desktop, I would LOVE to hear from you.

Thank you,

Jesse