Any plans for ConnectWise data source integration?

448ee0ba cef6-4fa1-8061-0ad4cf14d361 on 06 Jul 2020 00:11:03

RE: Any plans for ConnectWise data source integration?

Direct Query SQL connection to CWM is now possible. If you want to publish your reports, you need to set up an on-premise gateway. If you are a cloud partner, you need to either have CWM Premium or the cloud data access add-on ($75-200/month as of this posting).

Nathan Dufault | www.nexnow.net
Data, Reporting, Integration Services for ConnectWise

122ff6b4 4f78-4dba-b100-c6935f915b5d on 06 Jul 2020 00:05:11

RE: Any plans for ConnectWise data source integration?

'@Opal link had some new flaws recently pointed out, which mainly included CW changing the API to include a ClientID. Once the ClientID was added along side the authorization, the API resumed working. Along with the connection being insecure, the other aspect I found was you can't refresh from the Power BI service.

@Opal figured out another way of implementing this, which might be a hidden secret from CW. It is the ConnectWise Web Report URL Creator. Once you generate the string, you can pull back the requested information. It does include an encrypted string of the credentials and such, so still not entirely secure, but this way does allow for the Power BI Service to refresh the reports. It also doesn't require loops in the data to only pull back 1000 rows at a time.
https://na.myconnectwise.net/v2019_5/webreport/urlcreator/SetCredentials.aspx
(note version may change, so if link doesn't work, please review CW developer documentation)
If you need help or have questions, please let me know sales@opalbiz.com

New Blog: https://opalbiz.com/power-bi/link-power-bi-to-connectwise-manage/

@Opal has also started to develop a Connector for CW, if interested in more details, please reach out.

eaac784e ee8d-4d10-ac11-68ae4c9c5917 on 06 Jul 2020 00:01:13

RE: Any plans for ConnectWise data source integration?

Agreed this would be awesome especially if in CW Hosted where direct SQL access is not possible. For those waiting Opal have come up with a way to connect via REST but it looks insecure given the CW public and private key are passed in the http header.
http://365focused.com/view-connectwise-data-in-power-bi-via-rest-api/

fe80c7fc 5a1a-4cf9-8d7c-01fd9053958a on 05 Jul 2020 23:43:11

RE: Any plans for ConnectWise data source integration?

I would find this really useful. I have CW Manage connected on our Onprem sql database. But we also have a cloud hosted CW and would like to fully Integratei nto the API.