Software + Imagination
Power BI has an option to export reports to PDF and PowerPoint, which is very useful if you would like to share the reports in a static way with other people. To export a Power BI report to PDF or PowerPoint, first open the Power BI Report in the Power BI Service: Next, click File and choose Export to PDF: You will see the window: With options Current Values (exports … Continue reading How to Export Power BI Reports to PDF and PowerPoint
In this post, we will look at using the Power Query (M) Builder in XrmToolBox, developed by Mohamed Rashid and Ulrik “CRM Chart Guy” Carlsson. This tool is a great way to quickly help build Dynamics 365 reports in Power BI. It generates M queries with and without FetchXML as well as handles fields such as option sets. To install it, open the XRMToolBox and find the Power Query (M) Builder app. … Continue reading Using the Power Query (M) Builder for XrmToolBox to Generate M Code for Dynamics 365
When using JavaScript, we can display alerts in model-driven Power Apps. To do this, we can use openAlertDialog. The syntax for this method looks like below: Xrm.Navigation.openAlertDialog(alertStrings,alertOptions).then(closeCallback,errorCallback); As a simple example, we can use: var alertStrings = { confirmButtonLabel: “Got it”, text: “Something happened.”, title: “Alert Title” }; var alertOptions = { height: 500, width: 500 }; Xrm.Navigation.openAlertDialog(alertStrings, alertOptions).then( function success(result) { console.log(“Alert dialog closed”); }, function (error) { console.log(error.message); } … Continue reading How to Display an Alert in Power Apps using JavaScript
Did you know you can join Zoom calls from within Microsoft Teams? Let’s look at how to set this up. In Microsoft Teams, click on Apps in the bottom left: Search for Zoom and click on it: Click Add: Once added, we see the Zoom bot: Now let’s connect our Zoom to Teams. Click on My Meetings, then Sign In: Click Pre-Approve: Then click Authorize Click Accept: Zoom is now … Continue reading Join Zoom Calls from Microsoft Teams with the Zoom Teams App
To enable preview features for Microsoft Teams, do the following. In Teams, click on your user icon in the top right, then click About->Developer Preview: Select Switch to Developer Preview: You will now see it checked: That’s it, you will now have the preview Teams features.
Orders Table with 2019 data for use in Power BI and other examples. Order Number Amount Order Date Ship Date 1 100 1/1/2017 2/1/2017 2 150 2/1/2017 2/10/2017 3 200 3/2/2017 3/15/2017 4 250 4/3/2017 4/21/2017 5 200 1/1/2017 3/1/2017 6 300 10/1/2017 10/3/2017 7 110 1/1/2018 2/1/2018 8 160 2/1/2018 2/15/2018 9 210 3/5/2018 3/20/2018 10 280 4/6/2018 4/22/2018 11 210 1/2/2018 3/1/2018 12 100 1/1/2019 2/1/2019 13 200 … Continue reading Sample Date – Orders Table 2019
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