Posts

Updating Swagger in an Azure API Management Service

In this post, we will look at how to update Swagger in an Azure API Management service. Let’s continue from this previous example, where we created an Azure App Service. Our Swagger for this app service looks like this: If we go to our APIM in Azure, let’s add in this code. Click on swagger.json: We see the JSON. Get the URL: Paste it into the APIM Open Specification: We see … Continue reading Updating Swagger in an Azure API Management Service

Import Excel Data into a Model Driven PowerApp using Data Integration Project

In this post, we will import data from an Excel spreadsheet into a model-driven PowerApp, creating a Data Integration Project that uses Power Query. First, let’s look at a spreadsheet we have. It contains 2 accounts, with the account name and revenue: This spreadsheet is sitting in a SharePoint library. Let’s go to PowerApps.com and pull up our model-driven app. Select Entities: Clicking on Accounts, we can see the data … Continue reading Import Excel Data into a Model Driven PowerApp using Data Integration Project

Updating an Azure App Service through Kudu

In this post, we will update an Azure App Service using Kudu. First, go to https://portal.azure.com and select the Azure App Service to update. Then go to Advanced Tools, and Go: You may be prompted to log in. If you are, download the Publish Profile: You are now in the Kudu SCM portal. Go to Debug Console, then CMD: Backup the folder that you are deploying to, e.g. wwwroot: Click … Continue reading Updating an Azure App Service through Kudu

Assigning Power BI Service Administrator Role in Microsoft 365

The Power BI Service Administrator Role allows users to access the Admin Portal in the Power BI Service. To assign the Power BI Service Administrator role to a user, go to the Microsoft 365 Admin Center at https://admin.microsoft.com/. Select Users->Active Users: Select Manage Roles: You may need to select Additional Roles. Check Power BI Service Administrator. This is described as “Can manage all aspects of Power BI except license assignment. This … Continue reading Assigning Power BI Service Administrator Role in Microsoft 365

How to Export Power BI Reports to PDF and PowerPoint

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

Using the Power Query (M) Builder for XrmToolBox to Generate M Code for Dynamics 365

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

How to Display an Alert in Power Apps using JavaScript

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

Join Zoom Calls from Microsoft Teams with the Zoom Teams App

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

How to Turn on Preview Features in Microsoft Teams

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.  

Sample Date – Orders Table 2019

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