Forum Discussion
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.
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
- v-lili6-msft
Community Support
hi, abulman
Please refer to this document:
Note
To import your QuickBooks Online data into Power BI, you need to be an admin on your QuickBooks Online account and sign in with your admin account credentials. You can't use this connector with QuickBooks Desktop software.
https://docs.microsoft.com/en-us/power-bi/service-connect-to-quickbooks-online
Best Regards,
Lin
- abulmanFrequent 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
Community 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
- AnonymousNot applicableConnect to QuickBooks as an ODBC Data Source
- 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.
- Select the DSN in the menu.
- Select tables in the Navigator dialog.
- Click Edit to edit the query.