Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Power Bi Get data to quickBooks Enterprise

Hello Community,

 

I Have QuickBooks Enterprise on-premises, I want to connect that QuickBooks to my PowerBi?

How to do this?

I have checked the ODBC Connection and the DNS Record but I am confused where to setup DNS in QuickBooks Server or Source Server, I have also check the Source Server ODBC connection but its required Connection but how to do that.

Please help me for the same.

 

Thanks in Advance,

Pankil

  • Anonymous ,

     

    I'm afraid currently power bi only support QuickBooks online, you can click get data and select the QuickBooks connect in power bi service. Please refer to: https://docs.microsoft.com/en-us/power-bi/service-connect-to-quickbooks-online

     

    However, about the connector for QuickBooks desktop, I would suggest you to vote for this idea. Some comments are very meaningful there.

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support

    Anonymous ,

     

    I'm afraid currently power bi only support QuickBooks online, you can click get data and select the QuickBooks connect in power bi service. Please refer to: https://docs.microsoft.com/en-us/power-bi/service-connect-to-quickbooks-online

     

    However, about the connector for QuickBooks desktop, I would suggest you to vote for this idea. Some comments are very meaningful there.

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Freedup1's avatar
      Freedup1
      Regular Visitor

      Hi there....  Use QQube (www.clearify.com) to extract data out of QuickBooks.   Resulting database connects to PowerBI beautifully.  There may be other third party reporting tools for QuickBooks that also connect to PowerBI, but I have found QQube to be the most roboust and best.