Author: Carl

Installing R Studio for Power BI

In our last post, we installed R for Power BI. Let’s now install RStudio, which is an IDE for R. First, download R Studio from https://www.rstudio.com/products/rstudio/download/. We will install the free version: Select the Windows installer: This downloads the file below. Open it: Click Next: Select a path and click Next: Click Install: Click Finish: In Windows Start menu, we see the new RStudio folder with RStudio: Select it to open … Continue reading Installing R Studio for Power BI

Installing R for Power BI using CRAN Repository

To install R for Power BI on Windows, go through the following steps. First, we will download R for Windows. Go to the CRAN Repository and select Download for Windows: This will download the file below. Click to open it: Click OK: Click Next: Confirm the location and click Next: Select the files you need installed and click next. I will install on a 64-bit machine: Select customized startup or … Continue reading Installing R for Power BI using CRAN Repository

Post to Microsoft Teams based on Power BI Data-Driven Alert Using Microsoft Flow

In this post we will look at how you can perform an action based on a data-driven alert using Microsoft Flow. In our previous post, we looked at how to set up data-driven alerts. In our example, we created an alert for when our quantity on hand was less than 3 for our inventory item monitored by Power BI. To set up an action based on this alert, we can … Continue reading Post to Microsoft Teams based on Power BI Data-Driven Alert Using Microsoft Flow

Installing the App Studio for Microsoft Teams

To install, go to https://docs.microsoft.com/en-us/microsoftteams/platform/concepts/build-and-test/app-studio-overview and click on the link to download App Studio: Click to open Microsoft Teams (or you can launch the Web Client to do this): In Teams, click Add: You will be taken to the App Studio: You can also access App Studio by clicking on the 3 dots in the bottom left and then selecting App Studio:  

Configuring Max Number of Sessions in Unified Service Desk

In USD, we can set the Maximum Number of Sessions by using maxNumberOfSessions. To do this, go to the USD App and click on Options. Create an option called maxNumberOfSessions. Let’s set ours to 1: Once configured, USD will prevent users from starting new sessions when the maximum is reached. For example, if we have 1 session already running and the maximum is 1, when trying to start a second session, … Continue reading Configuring Max Number of Sessions in Unified Service Desk

Get and Set Field Values using FormContext and JavaScript with Dynamics 365 and PowerApps

In this post, we will look at how to get and set field values using FormContext and JavaScript. Let’s say we want to get and set the Website field of the Account form: Let’s do this on Save of the form. Edit the form and go to Form Properties: Create a new JScript web resource: Add the following code: function GetSet(executionContext) { var formContext = executionContext.getFormContext(); // Get value var … Continue reading Get and Set Field Values using FormContext and JavaScript with Dynamics 365 and PowerApps

Calling JavaScript Functions in Unified Service Desk running Unified Interface Pages

In this post, we will look at how to call JavaScript functions from Unified Service Desk running the Dynamics 365 Unified Client Interface. Let’s go through this. In my setup, the page I will run the JavaScript from is the Account page, which is set up in USD as a type Unified Interface Page running Chrome Process hosting type: First, let’s create a web resource. I have a solution called … Continue reading Calling JavaScript Functions in Unified Service Desk running Unified Interface Pages

Running FetchXML using Xrm.WebApi in Dynamics 365

In this post, we will look at how to run FetchXML using the Xrm.WebApi with JavaScript in Dynamics 365. First, let’s create some FetchXML. We will use the FetchXML Builder in XrmToolbox to create FetchXML with single quotes. You can use your preferred tool to create FetchXML: Now the code. We will place our FetchXML inside back ticks to create a multi-line string in JavaScript. We will then encode the … Continue reading Running FetchXML using Xrm.WebApi in Dynamics 365

Using the Power BI Horizontal Bar Chart Visualization

The Horizontal Bar Chart is a Power BI visualization from Microsoft. To install it, in Power BI Desktop, select Import from Marketplace: Click Add: Click OK: You will see the new visualization added: Let’s add some fields. We have a Revenue field and Total Amount Spent field. Let’s look at these by City: We can see the visualization is useful in comparing values: