Microsoft Power BI has Deprecated the QuickBooks Connector: Next Steps to Maintain Connectivity

Microsoft recently announced that the QuickBooks Online connector would be deprecated — no longer visible in the Power BI service starting June 2025 and removed from Power BI Desktop in the July  2025 release — thousands of dashboard users faced potential interruptions in their reporting workflows. This creates a difficult decision: should they completely change their accounting solution, or seek an entirely different BI solution? With Intuit deprecating QuickBooks Desktop, that’s no longer a reliable fallback either.

Faced with this disruption, now is the time to consider a better, future‑proof solution that restores connectivity right away, CData Connect AI.

The challenge: QuickBooks connector going offline imminently

• QuickBooks Online connectors are being phased out from Power BI beginning June 2025 in the Service and removed in the July  2025 Desktop release. The deprecation is set to roll out August  2025, immediately breaking any reports that use QuickBooks connectors.

• Customers must either build new workflows or move away entirely, which is time‑consuming and risky.

• The loss doesn’t just affect one connector, it fragments workflows, disconnects real‑time data, and risks breaking scheduled dashboards and reports.

How CData Connect AI restores real-time connectivity from QuickBooks

Seamless setup in minutes

Users simply log into QuickBooks Online and then connect to CData Connect AI from the Power BI “Get Data” experience. No downloading drivers or manual configuration—just secure, real-time connectivity brought back in minutes.

Real‑time, reliable connectivity

Instead of relying on a static connector that updates once a day or less often, CData Connect AI delivers real‑time data directly from QuickBooks Online to Power BI that can be automatically refreshed. That means dashboards are always current, without export jobs or data refresh waits.

Custom views and reusable dataset logic

CData lets users define custom views and mappings in Connect AI that cater to specific reporting needs — prebuilt filters, tailored fields, metrics, and joins. Once defined, these views are reusable. You don’t need to rebuild reports or datasets each time, upgrading your reporting workflow, not just replacing it.

Blend and extend across sources

Unlike the deprecated connector, Connect AI isn’t limited to just QuickBooks. It enables blending data from QuickBooks with CRM, ERP, or other line‑of‑business systems, giving analysts the power of cross‑system analytics and a full view of your business.

Extend beyond Power BI

Once inside Connect AI, your QuickBooks data can flow outside of Power BI and into automation platforms, AI assistants, analytics engines, and other tools — bringing modern flexibility to your data, no extra connectors needed.

Cost‑effective and trial‑ready

Connect AI offers affordable subscription pricing and a risk‑free free trial. You can test it immediately, restoring your QuickBooks‑to‑Power BI workflows and improving them along the way.

Try common queries with QuickBooks in the Data Explorer

After connecting to QuickBooks, try out some common SQL queries and views of data on the fly within the Data Explorer in Connect AI. Tweak and build your own views, or simply save these to make them available in Power BI to drag and drop right into reports and dashboards.

A brief setup walkthrough

1. Log into Connect AI and authenticate the connection to QuickBooks .

2. Select or set up custom views (like “monthly sales by region” or “open invoices by customer”).

3. Follow the Power BI setup instructions, then go to Get Data → More... → Online Services and select CData Connect AI.

4. Authenticate by signing into your Connect AI account.

5. Build or refresh dashboards as usual in PowerBI — with better performance and real‑time data.

Outcomes you’ll love

• Instant continuity: No disruptions, no rebuilding queries or dashboards.

• Better data, always: Real‑time QuickBooks data, fresh at every refresh.

• Reusable logic: Custom views live in Connect AI, reusable across reports.

• Multi‑source power: Blend QuickBooks with other data without extra connectors.

• Future‑proof workflows: Your data platform can grow beyond Power BI as needs evolve.

• Low risk, high value: Start with a free trial; upgrade reporting in minutes, not weeks.

Try out upgraded QuickBooks connectivity today

Power BI users facing the QuickBooks Online connector deprecation don’t need to scramble for a new solution. With CData Connect AI, you’re not just replacing a broken connector—you’re improving your reporting foundation. Test it risk‑free today with a 14-day trial.