Software + Imagination
When you log into Power BI, you are presented with a dashboard before you select any of the other dashboards. This is your featured dashboard. If you have not set a featured dashboard before, it will default to another dashboard. To set a featured dashboard, do the following. First, select the dashboard you would like to see when you log in, and click on the ellipse on the top right: Next, select “Set … Continue reading Power BI Featured Dashboard
In WebAPI, you may want to return JSON instead of the out of the box view, which looks like below: The out of the box code for the controller looks like as follows: To display JSON, change View to Json: In running this, you may get the error: “This request has been blocked because sensitive information could be disclosed to third party web sites when this is used in a … Continue reading Return JSON from WebAPI
To connect Power BI Desktop to Dynamics CRM Online, open Power BI desktop click on Get Data: Filter by Dynamics and select “Dynamics CRM Online”: Enter your OData URL and click OK. This will be in the format: https://*****.crm.dynamics.com/XRMServices/2011/OrganizationData.svc Select Organization Account and Sign In: Then click Connect from the same screen. This will load the entities from CRM.
To publish a web service from Visual Studio, do the following. You may need to install the Azure SDK for .NET. You can find the download link on the Microsoft 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 created with the instructions: And you can access the web service … Continue reading Publish Web Service to Azure from Visual Studio
There are situations where you create security roles in one organization and you need to transfer them to another organization, e.g. a development environment to a production environment. We will go through an example of how to do this. First, create a new security role: Next, add some permissions: Create a new solution and select the new security role: Now, in the destination system, select the security role: The new security role … Continue reading Deploy Security Roles Dynamics 365
To create a new record of an entity in Dynamics 365, use the code below: var account = {}; account.Name = “Sample Account”; var jsonAccount = window.JSON.stringify(account); if (typeof($) === ‘undefined’) { $ = parent.$; jQuery = parent.jQuery; } $.ajax({ type: “POST”, contentType: “application/json; charset=utf-8”, datatype: “json”, url: Xrm.Page.context.getClientUrl() + “/XRMServices/2011/OrganizationData.svc/AccountSet”, data: jsonAccount, beforeSend: function (XMLHttpRequest) { //Specifying this header ensures that the results will be returned as JSON. XMLHttpRequest.setRequestHeader(“Accept”, … Continue reading Create Record in Dynamics 365 using jQuery
You can query Dynamics 365 data by using jQuery. Here we will go through an example. We will be connecting to the OData Web service. The URL will be: https://yourcrm.crm.dynamics.com/XRMServices/2011/OrganizationData.svc/ To access the AccountSet data, the URL will be: https://yourcrm.crm.dynamics.com/XRMServices/2011/OrganizationData.svc/AccountSet We can pass parameters to the OData to filter the data if required. Add the following JavaScript code to somewhere in CRM. This will retrieve all accounts using jQuery and display … Continue reading Query Dynamics 365 using jQuery
The XMLHttpRequest is an API used in modern web browsers. It contains methods that allow communication between the web browser and a web server through JavaScript. Although the name is XML, it can also support JSON. Let’s go through an example of how to use it. First, we will use a previous example where we have a WCF web service set up. This service is then uploaded to Azure so it can be … Continue reading XMLHttpRequest Explained
In your JavaScript code, you may receive this error when running jQuery code: $ is not defined To resolve this, add the following code to JavaScript before the jQuery call is made: if (typeof($) === ‘undefined’) { $ = parent.$; jQuery = parent.jQuery; }
Windows Communication Foundation (WCF) web services can be created in Visual Studio. Note these web services replace the old asmx web services. To create a web service in Visual Studio do the following. Create a new project in Visual Studio and select WCF Service Application: This creates the solution: Delete the existing Service1.svc and IService1.cs and add a new WCF Service: This will create these 2 files again. Note the … Continue reading Create WCF Web Service in Visual Studio