Free migration assessment

SSRS migration to Power BI, Omni or Looker

Shearwater Data was founded by early Looker team members and has 100+ implementations and 8,000+ hours behind it. In a free migration assessment we look at your SSRS reports, datasets and subscriptions and tell you which ones move as paginated reports and which ones work better as dashboards.

  • Fixed-layout reports kept as paginated reports where the format matters
  • Operational and ad hoc reports rebuilt as dashboards on a shared model
  • Numbers are checked against SSRS before you switch

Request your free migration assessment

With a senior member of our team. You leave with a scope and a timeline. No preparation needed.

Please use your work email so we can prepare for your company.
Enter your name.
Enter your company.
Pick your current BI tool.
Pick a timeline.

A senior member of our team will email you to arrange a time. We use your details to reply to your request. See our privacy policy.

Thanks, we have your request.

A senior member of our team will email you within one business day.

Data teams we have worked with

  • Condé Nast
  • Bloomberg
  • Endeavor
  • Stairwell
  • Zapnito
  • TickPick
  • Laravel
  • Beatstars
  • TRM
  • Thought Industries
  • Central Retail
  • Tread
8,000+hours of Omni delivery
100+Omni implementations
Ex-Lookerfounded by early Looker team members

What the assessment covers

A working session on your report server. Bring whoever owns the reports and the stored procedures behind them.

  1. Your report server.Reports in use from the execution log, shared datasets and data sources, stored procedures, parameters, subscriptions and your SQL Server version.
  2. Sorting the reports.Which need a fixed printable layout, which are really tables that people export to Excel, and which nobody runs.
  3. Scope and timeline.A size band, the destination for each group of reports, and the order to move them in.
  4. Next steps.If it makes sense to go further, we scope the work with you from what we found.

Where each SSRS piece goes

Most report servers hold two kinds of report, and they go to different places.

Paginated reports

RDL reports that need a fixed layout, such as invoices, statements and regulatory output, move to Power BI paginated reports, which use the same RDL format. Layouts are checked page by page.

Interactive reports

Drill-down and parameter-heavy reports rebuilt as dashboards with filters in Omni, Looker or Power BI, on a shared model.

Datasets and stored procedures

Query logic moved into views or dbt models in your warehouse, so each definition is written once and every report reads it.

Subscriptions

Standard and data-driven subscriptions rebuilt as scheduled deliveries, checked recipient by recipient.

How the migration runs

Four stages, each with an output you keep.

  1. Inventory and sort.We read the execution log for the last 90 days and sort every report with its owner: paginated, dashboard or retire.
  2. Move the logic.Shared datasets and stored procedures are moved into the warehouse or the model, so each query lives in one place.
  3. Rebuild and parity test.Reports and dashboards rebuilt in priority order, each compared with SSRS on the same parameters and date ranges, with every difference logged and resolved.
  4. Cut over on your date.SSRS and the new reports run side by side until owners sign off, then subscriptions are switched over with a checklist for the exports people forget.

Who this is for

  • Teams on SSRS planning a SQL Server upgrade or a move to the cloud
  • Report servers where most reports are tables people export to Excel
  • A report owner who can sign off tie-outs

Who it is not for

  • Teams that only want SSRS upgraded to a newer SQL Server version
  • Teams with a handful of reports

The team behind it

Jeff Garcia

CEO

Spent about eight years at Looker, from 2013 to 2021.

Andrew Searson

Chief Data Officer

Early Looker team member who has led data analytics for 17+ years, building self-service data organizations.

Bruna Baungarten

Director of Delivery

Leads the Shearwater team that runs your project.

Questions

What does the assessment cost, and what do we commit to?

The assessment is free and you commit to nothing. If you go ahead, the migration is scoped as a project from what we learn in the assessment.

Can our SSRS reports move to Power BI as they are?

Many can. Power BI paginated reports use the same RDL format, so fixed-layout reports often move with small changes to data sources and parameters. Custom code, some subreport patterns and some data sources need rework. The assessment lists which reports fall where.

Should every report stay paginated?

Usually not. Many SSRS reports are tables people export to Excel to analyze. Those work better as dashboards with filters, where users can slice the data themselves. We sort each report with its owner.

How long does an SSRS migration take?

Moving 50 to 150 reports usually takes 6 to 12 weeks. Larger servers, heavy stored-procedure logic and data-driven subscriptions add time. The assessment gives you a range for your own server.

Why move to Omni or Looker instead of Power BI?

If your team wants self-serve analysis on a cloud warehouse, Omni and Looker give business users a governed model to explore. If you need fixed-layout output, Power BI paginated reports fit that job. Some teams use both.

How do you make sure the numbers match?

Every migrated report is compared with its SSRS original on the same parameters and date ranges, and each difference is explained or fixed in a tie-out log the report owner signs. SSRS stays on until sign-off.

Could we have an AI agent convert our dashboards ourselves?

It can redraw charts, and we use AI tooling ourselves. The hard part is the model underneath: shared definitions, access rules, schedules and proof that the numbers match before you switch. That is the work we do, and the AI helps us do it faster.

Is the assessment a sales call?

It is a working session on your setup with a senior member of our team, which was founded by early Looker team members. If a move makes sense, we offer to scope it. If it does not, we say so.

What do you need from us, and how long is the call?

Nothing in advance. The call runs up to an hour on Google Meet. Bring whoever owns the model and we look at your setup together.

“Shearwater gave us back the Looker support that we missed on the tool that we love, Omni. They have operated as an extension of our team and are exceptional partners.”
Ben Beebe, CFO, Stairwell

Sort your SSRS reports before you move them

Free, with no commitment. You leave with a scope and a timeline.

Request my free assessment

Shearwater Data is an Omni implementation partner.

© 2026 Shearwater Data. All rights reserved.

Privacy Policy

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.