Forum Discussion
black_magic1001
5 years agoHelper I
Cdata Quickbooks Remote Connection
I have a client who has power bi installed on his local desktop. He is trying to get data from quickbooks desktop (direct query or import, doesn't matter) that is hosted on a separate server using a...
Greg_Deckler
5 years agoCommunity Champion
According to the documentation here:
- black_magic10015 years agoHelper I
That ODBC is configured on the machine that hosts power bi correct? And then that ODBC looks at that URL and send the USER/PASS to make a connection to the QuickBooks Remote Connection Server, which then makes the connection to quickbooks? Does that sound right.
Is the IP of the server I need in IPCONFIG as the ipv4?
- Greg_Deckler5 years agoCommunity Champion
black_magic1001 - Yes, the IP v4 address should work fine. Open a command prompt (cmd) on the server. Type ipconfig and hit the Enter key. There you can see the ip address of the server.
- black_magic10015 years agoHelper I
I made a SO post about this issue: