Installing Microsoft SQL Server AdventureWorks Sample Data

Microsoft provides sample SQL Server databases called AdventureWorks. You can download the files from the CodePlex website for your relevant SQL Server version here – http://msftdbprodsamples.codeplex.com/. You can then attach…

Installing Power BI Desktop

…submitted to the Ideas section of the Power BI forums – see here). To install the tool, go to https://powerbi.microsoft.com/en-us/desktop/ and download the latest application. You have 2 options to…

Creating and Debugging a Unified Service Desk Custom Hosted Control

…website here: https://marketplace.visualstudio.com/items?itemName=DynamicsCRMPG.MicrosoftDynamicsCRMSDKTemplates Open Visual Studio. Create a new project, and under the CRM SDK Templates, select Unified Service Desk. Select UII WPF Hosted Control: This will create a project…

Dynamics 365 Troubleshooting User Access

…Basic, BusinessUnitId: 7e027aa6-8713-e711-810c-c4346bac6954</Message> The privilege name is prvAppendmsdyn_PostAlbum. We can determine what security is required from the Microsoft link below: https://msdn.microsoft.com/en-us/library/hh547441.aspx Searching for prvAppendmsdyn_PostAlbum we can determine the problem is…

Publish Web Service to Azure from Visual Studio

…website: https://azure.microsoft.com/en-us/downloads/archive-net-downloads/ Select the web service. Right click and publish:   Select Microsoft Azure App Service and New: Confirm the details and click Create: Press Publish: A webpage will be…

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  …

Install SQL 2016 Sample Databases

…features. To install the database, go to: https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0 We will restore a local database and local data warehouse. Database is installed: Restore the data warehouse, place the file in a…

Power BI Gateway Installation

…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…

Dynamics CRM Retrieve Multiple and Query Expression

…Microsoft.Crm.Sdk.Messages; using Microsoft.Xrm.Sdk.Query; Then add code to connect to CRM: var connectionString = @”AuthType=Office365;Url=https://yourcrm.crm.dynamics.com/;Username=you@username;Password=yourpassword”; CrmServiceClient conn = new CrmServiceClient(connectionString); IOrganizationService _orgService; _orgService = (IOrganizationService)conn.OrganizationWebProxyClient != null ? (IOrganizationService)conn.OrganizationWebProxyClient : (IOrganizationService)conn.OrganizationServiceProxy;…