Forum Discussion

abulman's avatar
abulman
Frequent Visitor
7 years ago
Solved

Connecting to Quickbooks

Hello,

 

When I connect the Power BI web service to the QBO preview app it created a new workspace along with a dataset which I could use to create visuals. However, when I connect to my company's actual data  all I got were some dashboards and reports which I could not manipulate. I have no access to the actual dataset nor did it create a new workspace. Any help would be greatly appreciated.

  • abulman's avatar
    abulman
    7 years ago

    Hi Lin,

     

    Thanks for your reply.

    I actually am the admin of my Quickbooks online account so that is not the issue.

    What I found after further experimenting was that if I navigated to the QBO App via the Service Content Pack and connected that way it did create a dataset with my Quickbooks data.

     

4 Replies

    • abulman's avatar
      abulman
      Frequent Visitor

      Hi Lin,

       

      Thanks for your reply.

      I actually am the admin of my Quickbooks online account so that is not the issue.

      What I found after further experimenting was that if I navigated to the QBO App via the Service Content Pack and connected that way it did create a dataset with my Quickbooks data.

       

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

        hi, abulman 

        Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

         

        Best Regards,

        Lin

  • Anonymous's avatar
    Anonymous
    Not applicable
    Connect to QuickBooks as an ODBC Data Source
    1. Open Power BI Desktop and click Get Data -> ODBC. To start Power BI Desktop from PowerBI.com, click the download button and then click Power BI Desktop.
    2. Select the DSN in the menu.
    3. Select tables in the Navigator dialog.
    4. Click Edit to edit the query.