The post Using Power BI & SharePoint Online to Solve the QuickBooks Online “Type” Void discusses how the three products can be brought together to improve management reporting and fill a void in QuickBooks Online (QBO). I will be publishing more posts on how SharePoint Online and Power BI can address other reporting voids in QuickBooks Online. Therefore, I thought it would be a good idea to first list the tables currently available through the Power BI Desktop Content Pack for QuickBooks Online. The post QuickBooks Online & SharePoint Online Synchronization Revisited provides some additional background information.
Below is a screen shot of the current QuickBooks Online tables listed in the Power BI Desktop’s data source Navigator. As you can see there are 39 tables and 2 functions.
Power BI tries to figure out the table relationships for all but a dozen or so tables but doesn’t do a great job of it. Many of the tables are also de-normalized so you don’t need them all to do reporting. The GeneralLedger table is a good example because it contains Account Name, Customer Name, etc.