QuickBooks Online Tables via Microsoft Power BI Desktop Content Pack

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s