The new Jet Analytics explained: cloud, Fabric and Power BI

insightsoftware and TimeXtender launched a new, cloud-managed Jet Analytics in June 2026, with native Fabric and Power BI support. What it is, what stays, and what Dynamics customers should do.

The short answer

Jet Analytics is insightsoftware's data warehouse and analytics product for Microsoft Dynamics. On 1 June 2026 insightsoftware and TimeXtender launched a new, cloud-managed version of it, with native support for Microsoft Fabric, Power BI, Azure Data Lake and Snowflake. The classic, SQL Server-based Jet Analytics stays available. If you run Business Central, NAV, GP or Finance and Operations and already own Jet, nothing is being taken away. If you are choosing a reporting route for Dynamics now, there is a new option on the table, and it changes the comparison.

Hopton is a Jet Analytics partner for the UK and Ireland. This post sets out what the new platform is, what stays the same, and what we would do in each of the three situations we see most often.

What Jet Analytics has always done

Dynamics stores its numbers in tables designed to record transactions, not to answer questions. A sales report that finance would recognise can need data from a dozen or more tables, and the joins are not obvious. For years Jet Analytics has solved that by taking the data out of Dynamics, reshaping it into a governed data warehouse with pre-built data models, and making those models available to Excel, through Jet Reports, and to Power BI.

The product most customers run today is Jet Analytics Classic: SQL Server in your own environment, managed through the Jet Data Manager, refreshed on a schedule you set. It works, it is well understood, and a lot of UK finance teams have run month end on it for a decade.

What is new in the 2026 release

A cloud-managed platform

insightsoftware describes the new Jet Analytics as replacing the fragmented stack of ingestion, transformation and observability tools with one cloud-native platform. Updates are continuous rather than version upgrades you plan and test yourself.

Native Fabric, Power BI, Azure Data Lake and Snowflake

The platform writes its governed model to the destinations businesses are standardising on. For a Microsoft estate that means OneLake and Fabric, with Power BI on top. For the few mid-market firms on Snowflake, it lands there instead.

Visual transformations that become Spark code

You design transformations visually and the platform generates PySpark. There is no hand-written code to maintain, which matters for finance-led teams who do not have a data engineer on staff.

Pre-built Dynamics data entities and a consistent semantic layer

This is the part that matters most to a finance director. Gross margin, ageing buckets and revenue recognition get defined once, in the model, and every report inherits the definition.

Instance Blueprints and a zero-access security model

Blueprints are templates that cut new-environment setup, in insightsoftware's words, from days to hours. The zero-access model means the platform orchestrates your data without holding a copy of it: the data stays in your own cloud tenant.

An AI framing

insightsoftware pitches the platform as a way to build a governed, AI-ready data foundation up to ten times faster than manual development. Jennifer Warawa, insightsoftware's President, put it plainly at launch: "AI isn't magic, it's only as reliable as the data behind it." We would say the same. The thing that decides whether data gets used is whether anyone trusts the number, and AI raises the stakes on that rather than removing them.

What happens to Jet Analytics Classic

It stays. insightsoftware calls this a dual-platform strategy: the new cloud platform for organisations moving to Fabric or Snowflake, and Jet Analytics Classic for those that need SQL-centric, on-premises or air-gapped deployments. There is no forced migration and no end date has been announced.

What we tell existing Jet customers is simple. There is no rush. Keep running month end on what works. Decide when Fabric is on your own roadmap, not insightsoftware's, and plan the move then, with the old and new models running side by side until the numbers reconcile.

Jet Analytics or Jet Reports?

People mix these up, and the June 2026 renaming did not help. Jet Reports is the Excel reporting tool. It reads directly from Business Central through an extension that is now called "insightsoftware Reporting for Business Central". Jet Analytics is the data platform underneath, the governed warehouse that Excel, Jet Reports and Power BI can all report from. Jet Reports on its own is quick to start and good for a single company. Jet Analytics is what you add when you need several companies, history from an old system, or Power BI across the business. Many organisations run both.

How it compares with the other routes

For Business Central specifically, we describe three routes to reporting: Microsoft's own Power BI apps, a semantic model or ready-made tool over Business Central, and a Fabric data platform. The new Jet Analytics sits between the last two. It gives you a governed warehouse that you own, in your own tenant, landing in Fabric, with far less engineering than building the lakehouse yourself.

The other ready-made option we work with is Cosmos, a cloud reporting tool built for Business Central with a structured data model, around 30 Excel reports and pre-built Power BI packs. The honest distinction is ownership. Cosmos gives you a reporting tool with nothing to build or run. Jet Analytics gives you a data platform you own and extend. We partner with both, and we wrote up how we make the Jet vs Cosmos decision earlier this year.

What we would do in each situation

Already on Jet Analytics Classic and happy

Stay. Put Fabric on your roadmap if it is not already, and ask us to map your current Jet model against the new platform so the eventual move is a reconciliation exercise, not a rebuild.

Several companies, or a NAV or GP migration on the way

The new Jet Analytics is a strong fit. The governed model holds history from the old system beside the new one, and it lands in Fabric, so the rest of your estate can sit alongside it later.

One company, and you want reports this quarter

Look at Microsoft's Power BI apps first, then Cosmos. Jet Analytics is more platform than you need today.

Working with Hopton on Jet Analytics

We implement Jet Analytics, train your team and support it after go-live, as part of a wider view of your data estate rather than a reporting project on its own. The usual starting point is a free audit of how your teams report from Dynamics today, which tells you whether Jet Analytics, Cosmos or a Fabric platform is the right answer before anyone commits. Details are on our Jet Analytics partner page, or get in touch.

What is the new Jet Analytics from insightsoftware, and what does it change for Dynamics and Business Central reporting?