IMO, QuickBooks clearly doesn't care about their desktop customers, and are trying to push everyone to QB online.įor accessing ODBC data in MS Excel you need to use Get Data/Other Sources/Microsoft Query method. I couldnt even see the full names of my tables in an unreiszable tiny little window.

What pissed me off even more, was even if I wanted to use Excel the Microsoft Query interface you are forced to use is so, so, old. going through Access is absurd, and there is no way im going to do that.

I ended up manually exporting reports in Excel, saving them to Sharepoint, and mashing them up in BI with on premises SQL data before publishing ot the BI web service.ĭetails below. There is a User Voice request open with Microsoft for this feature, but I have a feeling QB is not going to give up their leverage on their users. I tried a support thread with the company that makes the ODBC, and they basically told me QuickBooks has been like this for 17 years and counting, and they have zero hope of improvements. The ODBC that quickbooks provides seems to be hard coded for certain apps. I tried to chase this down a couple of rabbit holes but its not supported.

Turtle Works LLC 586.206.8960 | email: new insights into cash flow, profitability and customers. With our understanding of QuickBooks, databases, online services and data modeling, we design and build data sets, models, reports and dashboards to satisfy the situation and need.įrom a laptop, tablet or phone, see how cash on hand, payables and receivables add up know your cashflow position. The consolidated reporting gives you one place to understand your business. Power BI breaks through barriers, pulling together data from hundreds of different locations, into one data model. Let us show you the proven strength of Power BI modules that connect to QuickBooks to access KPI metrics, dashboards and reports that ease your mind.Ĭonsolidate QuickBooks data with data stuck in Excel, online apps or internal systems. See how many proposals are out, how much they are worth and to whom they were sent.

Determine which customers to call, how much they owe and how late they are. Know how much money is outstanding from clients. IF YOUR ANSWER IS = YES TO ANY OF THE QUESTIONS ABOVE THEN THEN DASH IS FOR YOU - LEVERAGE QUICKBOOKS AND MICROSOFT POWER BI.ĭon't miss the opportunity to discover answers from every angle: Subject: Get More From Quickbooks w/ Power BI VERSION 2

Quickbooks desktop app issues