Posts

Introduction to OAuth

OAuth is an open standard for authorization of websites and applications. It provides these applications with a simple, secure way allow their users to access their data. For example, let’s say you are a developer building an application. OAuth allows you to delegate the authorization. There are many websites and mobile applications that use Facebook or Google to authentication users. This is done through OAuth. OAuth has many benefits. The framework does … Continue reading Introduction to OAuth

Using DAX YEAR

DAX has various date functions we can use to help us visualize data. Let’s go through an example. In our dataset, we have order lines and we have the orders associated with them. Orders have a date field, i.e. when our customer placed the order: We have an active relationship in Power BI matching our orders and lines: We can derive the year, month, day, hour, minute and second from … Continue reading Using DAX YEAR

Unified Service Desk – Close Action

In Unified Service Desk, one of the actions associated with a hosted control is the Close action. This action is useful if you would like to close a hosted control that has been loaded. For example, in the case below, we have a custom hosted control that displays dashboard in a tab: To close this, we can run the Close action. We can do this from the Debugger, or anywhere … Continue reading Unified Service Desk – Close Action

Connecting to Dynamics 365 using the Organization Service Proxy

We will connect to Dynamics 365 from a console app using the Organization Service Proxy. To do this, create a new console app. Add the assemblies: Microsoft.Xrm.Sdk System.ServiceModel (for ClientCredentials) We will also add Microsoft.Crm.Sdk.Proxy to get the version info from Dynamics 365. Add using statements: using Microsoft.Xrm.Sdk.Client; using System.ServiceModel.Description; using Microsoft.Crm.Sdk.Messages; Now the code to connect to Dynamics 365: using System; using System.Linq; using Microsoft.Xrm.Sdk.Client; using System.ServiceModel.Description; using Microsoft.Crm.Sdk.Messages; namespace … Continue reading Connecting to Dynamics 365 using the Organization Service Proxy

Useful Dynamics CRM and Dynamics 365 Links and Blogs

Below are some links that may be useful: Dynamics CRM Forums at Microsoft Web API Entity Reference at Microsoft Dynamics 365 Team Blog Blogs Hosk’s Dynamics CRM Blog Salim Adamon XrmToolBox Tanguy Touzard WOODSWORKBLOG Zsolt Zombik develop1 Scott Durow Rajeev Pentyala Gustaf’s Blog Jason Lattimer Deepesh Somani David Yack Neil Parkhurst Surviving CRM CRM Musings Work and Study Book James OConner Andrii Butenko CRM Tip of the Day Jonas Rapp, GitHub … Continue reading Useful Dynamics CRM and Dynamics 365 Links and Blogs

Dynamics 365 Power Apps Workflows vs Plugins vs Actions

In Dynamics 365 and Power Apps, Workflows, Plugins and Actions are used to automate business processes.They allow businesses to hook onto events that occur in the system. Here we will look at the differences between the two and when to use which one. Let’s summarize with the table below: Type Triggers Synchronous and/or Asynchronous Tool Workflow Create, Fields Change, Status Change, Record Assigned and Deleted Asynchronous (background) or Synchronous (real-time) Process … Continue reading Dynamics 365 Power Apps Workflows vs Plugins vs Actions

D3 Hello World

To create a D3 “Hello World”, do the following. Go to the d3js.org website and find the latest D3 version: Copy the link to the latest release: <script src=”https://d3js.org/d3.v4.min.js”></script> Create an HTML page and add the following code, with the link above: <!DOCTYPE html> <meta charset=”utf-8″> <body> <script src=”https://d3js.org/d3.v4.min.js”></script> <script> d3.select(“body”).append(“span”) .text(“Hello world”); </script> Run the page:  

C# Dictionaries

Dictionaries are used in C# to define key value pairs. They are part of System.Collections.Generic. The format is: Dictionary<key,value>   To define a dictionary, use the format: Dictionary<datatype, datatype> d = new Dictionary<datatype, datatype>(); For example: Dictionary<int, int> d = new Dictionary<int, int>(); or Dictionary<string, int> d = new Dictionary<string, int>(); To add to the data type, you can do either: Dictionary<string, int> d1 = new Dictionary<string, int>(); d1.Add(“Bob”, 12345); or d[3] = 30; From there, you can use different methods on the dictionary such as ContainsKey, ContainsValue: if (d.ContainsKey(2)) {     Console.WriteLine(d[2]); }  

Add Data Source to Power BI Gateway

In Power BI, select Manage Gateways: Select Add data sources to use the gateway: Give the name as Excel Spreadsheet and the type as File: Provide the path to the file and also the windows username and password: You can add multiple data sources by selecting Add Data Source:  

Power BI Gateway Installation

To use the Power BI Gateway, run the executable after downloading from Power BI: You will see this window below: Click Next: Enter email address to sign in: Add gateway name and key: Gateway installed: Service settings: Diagnostics: Network: Now in PowerBI.com, go to Manage Gateways: You can now see the new gateway: Note the differences between the Personal Gateway and the On-Premise Data Gateway: Personal gateway On-premises data gateway Cloud services it … Continue reading Power BI Gateway Installation