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

Dynamics 365 Get Id of Current Record with JavaScript

To get the Id of the current record: var id = Xrm.Page.data.entity.getId(); To get the entity name: var entityName = Xrm.Page.data.entity.getEntityName(); For more information see the Microsoft website: https://msdn.microsoft.com/en-us/library/gg334720.aspx  

Web Resource Project with Dynamics 365 Developer Extensions (3rd Party)

Using the Developer Extensions 3rd Party project for Dynamics 365, you can set up a Web Resource project to help you deploy web resources to your Dynamics 365 environment. To do this, first make sure you have installed the developer extensions for Visual Studio. Next, create a new CRM Web Resource project: This will create the project below: Next, right click to create a new JavaScript file: Enter a name … Continue reading Web Resource Project with Dynamics 365 Developer Extensions (3rd Party)

Installing Dynamics GP SSRS Reports

In this post I will show you how to install Dynamics GP SSRS Reports. Firstly, ensure SSRS is installed on your SQL server. If not, install it. Go through the configuration to ensure SSRS is set up and ready to use. Next, start GP. Go to Tools->Setup->System->Reporting Tools Setup: From the window below, enter your Report Server URL and Report Manager URL select Deploy Reports: You may get this message … Continue reading Installing Dynamics GP SSRS Reports

Uninstalling the USD Client

To uninstall the Unified Service Desk client, go through the following steps: Browse out to Programs and Features: Find Unified Service Desk Setup Support Files: Click Uninstall. You will see below, click Uninstall again: Click Yes: USD client is now uninstalled. Browse out to the folder in Windows where USD was originally installed, usually: C:\Program Files\Microsoft Dynamics CRM USD\USD C:\Program Files (x86)\Microsoft Dynamics CRM USD If this directory still exists, … Continue reading Uninstalling the USD Client

Using the Postman REST Client

The Postman REST client is a client application that has a Chrome extension. Here we will go into how to install and use the client. Go to the Chrome web store: https://chrome.google.com/webstore/category/extensions?hl=en Search for Postman. You will see this app below. Click Add To Chrome: You will see this Postman link below: This will open the page: And after that: Enter a REST URI, e.g. https://www.googleapis.com/books/v1/volumes?q=isbn:0747532699 The response is returned: You can change the … Continue reading Using the Postman REST Client

Power Query Language M Start of Week

There is a function called StartOfWeek that displays the start of the week in Power Query formula language. Syntax: Date.StartOfWeek(<date>) The week starts on Sunday and runs through to Saturday. To use Monday to Friday, you can add a day to it using the function Date.AddDays(<date>, 1).