Nilhan Perera

Sup Folks! On my last blog I spoke about   Integrating data onto Power BI from INSIGHTLY CRM  (link below) https://nilhanperera.blogspot.com/2019/10/integrating-data-onto-power-bi-from.html On today's blog, lets have a look at Using Azure Data Factory (ADF) to Copy Data from INSIGHTLY CRM onto Azure Data Lake (ADL). Much like the previous post we need to use the API provided by Insightly to get access to data. Let's have a look at the steps needed to do this Pre-requisites 1. Access to INSIGHTLY. You can sign up for a Free 14 Day Trial. 2. Subscription to Azure Data Factory  3. Azure Data Lake Storage 4. Azure Storage Explorer Please have a look at my previous post to get an idea on how to obtain the API key and Request URL. Steps 1. Test the Request URL using Postman ( Chrome Extension Given Here ) Select the GET Method and paste the request URL  Select Basic Authentication from the drop down list In...

Hi Guys, The other day I was looking at possibilities to get data from INSIGHTLY and visualize it through Power BI. I was given the following link that lead me to the INSIGHTLY Developer portal, https://api.insightly.com/v3.1/Help#!/Overview/Technical_Details and I came across the following article that showed how to directly connect the REST API to Power BI, https://dev.applicationinsights.io/documentation/Using-the-API/Power-BI I followed the steps mentioned on the page associated with the link above and voila! it worked! However, the above article talks about "Displaying a time series using the Metrics API". Let ma explain how this can be applied to get data from INSIGHTLY. For this example, lets look at the steps required to get Project related data onto Power BI. Pre-requisites 1. Access to INSIGHTLY. You can sign up for a Free 14 Day Trial. 2. Power BI Desktop. Steps 1. Login to INSIGHTLY CRM > Navigate to the user menu and se...

Hey Guys, It’s been awhile :p So, I was working on a little project where I wanted to show a proper route that was mapped correctly (much similar to google maps) on Power BI, however there was no visual supporting it at the time. As always, I looked into alternatives for this and I found a visual called route maps on the market place by Weiwei Cui. Figure 1 : Route Map - PBI Marketplace I was also able to find the guide for this visual (link below) https://weiweicui.github.io/PowerBI-Routemap/ This did not quite do the trick as it showed the displacement of the two inserted locations and not the route to it. Figure 2 : Incorrect Route (Displacement) I was getting a little annoyed this point, so I googled alternate options and I found out these things. The ability to create customs points on google maps The ability to export it in KML/KMZ Format The ability to convert it to an Excel file ...