Menu

Power BI Direct SQL Connect for Cloud
or On-Prem ConnectWise Manage

Get unmatched access to your data with Power BI

Save time

Running into too many roadblocks with your Report Writer reports? Is your team spending too many hours on what should be a simple report? A lot has changed in the decade since Report Writer has last seen an update. Take advantage of what a modern reporting tool has to offer.

Migrate Reports

Export your SQL code from Report Writer or another reporting tool into Power BI. Recreate Report Writer or BrightGauge reports and dashboards.

As part of your setup, NexNow will show you how to get a dataset into Power BI. If you choose, we can help you recreate the design as well.

Unlock your data

Missing advanced JOIN, UNION, and other SQL functionality? Query your data however you need to and even use SQL2012+ functions that don’t work in Report Writer. Power BI gives you the power to start with a custom SQL view. Getting the data in the shape you need it beforehand makes simple table/graph reports as easy as drag and drop.

Instant Refresh

Tired of waiting 30+ seconds each time you load a report or change a filter in Report Writer? With SQL access to your ConnectWise data, your reports will refresh instantly as you click on report elements.

Access During Outages

Continue to see your Manage report and dashboards even during outages that prevent SSO login. As long as the database is connectable, you can continue to access your data securely via your Power BI Gateway.

Data Security

Unlike Report Writer, giving someone access to the tool does not have to mean they can access everything in your database, regardless of user security settings. Choose who has access your reports, whether they can edit reports or create their own, and if anything should be filtered out in their report views.

Choose 1 or more

$999

Chose from the options below for $999 each:

Power BI On-Premise Gateway Setup*

5 hours of training or report building in Power BI Desktop, Service, or Report Builder

Implement a pre-built NexNow report (contact us for examples)

Implement up to 3 additional gateways for failover or load balancing

Get Started

Choose 3

$2,499

Choose 3 products from the previous list. 

Want more? Contact us for a customized quote.

Get Started

Custom

Quote

Do you have full reports you’d like us to design and build or migrate over from another reporting tool? Have another unique Power BI request?

Choose this option to contact us about a custom solution.

Get Started

FAQs

Here are some frequently asked questions.

*WHAT IS A GATEWAY SETUP? DO I NEED IT?

The Power BI Gateway is installed on a local server and is what allows you to collaborate on reports with your team and view them in mobile apps. Without it, you are limited to viewing reports files in Power BI Desktop in a Windows environment.

What are the requirements for the Power BI On-Premise Gateway?

  • A local always-on machine running Windows and latest .NET 
  • A 365 account to remain logged into the gateway service
  • Power BI Pro license applied to the 365 account (as well as any other user accounts that are collaborating on reports)

Do I need Power BI Pro licensing?

In order to get the full benefit of the Power BI service, yes. You can fully use Power BI Desktop with a basic Office 365 E3 plan and you can publish your reports to your own workspace. However, to collaborate on reports or to access them remotely via the on-premise gateway, you need a Power BI Pro license.

How much does Power BI Pro cost?

If you are a Microsoft Partner, you likely already have a set of licenses you can apply to your users at no additional cost. Power BI Pro is also included with Office 365 E5. If neither of these apply, you can add it on per-user for $10/month for US Office 365 customers. 

How much does ConnectWise SQL access Cost?

ConnectWise changes pricing packages from time to time so the best source for this is your account manager (accountmanager@connectwise.com). 

SQL access is included by request with ConnectWise Premium. Otherwise, expect to pay $50-200 per month depending on the number of users.

Didn’t find your answer?

Our heroic support team can help you.
Contact Us