Software + Imagination
In Power BI Desktop, we can automatically detect data types of the fields we are importing. This is useful in that we don’t need to go through every field and define its type. This feature can be turned on and off. Let’s go through an example of how to use it. In Power BI, go to File->Options and Settings->Options: Select Data Load, and under Type Detection you will see Automatically … Continue reading Automatically Detect Data Types in Power BI
To check the Service Health of Microsoft 365 services, log into https://admin.microsoft.com. Click Show All on the left: Then Health->Service Health. You will see a list of all services: Selecting Advisories will give you details on any current issues. In this case, “Users may be unable to create Skype for Business meetings for Outlook events through Outlook on the web”: Click on Show Details to see more details: You can also … Continue reading Checking the Service Health of Your Microsoft 365 Services
The recent release of Unified Service Desk 4.1 brings support for Chrome and Edge processes, which should bring performance enhancements over previous releases of USD which were limited to IE processes. To upgrade to USD 4.1, see here. In this post, we will look at how to use Chrome and Edge with USD. Note Edge support is still in preview. Go to USD settings in Dynamics 365 and open a … Continue reading Using Chrome and Edge in Unified Service Desk 4.1
In Dynamics 365, when a developer publishes a customization, users may see a page refresh. This piece of code appears to be specific to using legacy forms. We will demo this with the Account form. Go to the account, and press F12 to open the developer tools: Search for _metadatacacheversion: Open the JsProvider.ashx version (other files may run during other circumstances). Click the curly braces to Pretty Print the file … Continue reading Posting Customizations Causing Page Refresh in Dynamics 365
In Dynamics 365, it is easy to create dashboards that users have access to that display critical information. In this post, we will look at how to build an Opportunity dashboard. Select Dynamics 365 Dashboard: We will choose the 3-column regular dashboard layout and click Create: We see below: Give the dashboard a name: In each pane, we can add: Chart List Relationship Assistant IFrame Web Resource Power BI tile … Continue reading Creating a Dynamics 365 Dashboard showing Opportunity Data
Let’s look at how to open an SSRS RDL Report in Visual Studio 2017 and Visual Studio 2019. First, download the Microsoft Reporting Services Project extension at: https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftReportProjectsforVisualStudio We see this applies to Visual Studio 2017 and 2019: You will see the file downloaded. Open it: You will see: Be sure to close any Visual Studio instances running. Click Install: We can now create Report Server Projects in Visual Studio. In … Continue reading How to Open an SSRS RDL Report in Visual Studio 2017 and 2019
In this post, we will look at how to switch between GitHub branches in Visual Studio. First, open a solution that is connected to a GitHub repository and go to Branches: In this case, we have several branches – Master, release1, release1a, etc. We also have remote GitHub branches. We see the active branch in brackets, in this case master: Let’s open the Program.cs file in the solution: Now, if … Continue reading Switching Between GitHub Branches in Visual Studio
Let’s follow on from the example of creating a new branch in Github. We used 2 methods to create 2 branches, Release 1 and Release 2, from the Master branch. Let’s now create a branch of a branch. We will create Release 1a from Release1, and Release 2a from Release 2. Master currently looks like this: Method 1 – Visual Studio Here we are in Visual Studio in Release 1. … Continue reading Creating a Branch of a Branch in GitHub
ExecuteMultiple in Dynamics 365 is used to execute multiple requests, as opposed to executing requests one at a time. For example, if you wanted to create 5 contacts in Dynamics 365 through code, you could call Create 5 times, or you could call ExecuteMultiple once, with the 5 entity objects defined. This is useful if network latency is an issue. Let’s create a console app that creates 5 contacts using … Continue reading Using ExecuteMultiple C# in Dynamics 365
In this post we will look at how to use Upsert to insert/update a record in Dynamics 365. Let’s say we have a contact in the system, Bob Smith: We would like to do an upsert on Bob Smith. To do this, we need to find his record using a key, so the system can decide whether to do the insert or update. To do this, we use Alternate Keys. … Continue reading Using Upsert In C# Dynamics 365