Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
ntesllc
Level 2

Reply to message

serghio 

I am currently using Power BI with QBO.

1. Log into your QBO account first.

2. Launch Power BI Desktop & choose Get Data; in the search window type in Quickbooks

3. Select QBO Beta and connect.

This will download all tables and does not download GeneralLedger table.

For that you will need to create a blank query next:

Power BI Desktop ---> Transform Data--->New Source ---->Blank Query:

insert the following and it will take you to a list of tables and click on GeneralLedger :

= Source{[Key="generalledger"]}[Data]

 

Need to get in touch?

Contact us