Software + Imagination
The Postman app is useful as a developer if you want to send requests and see responses when interacting with Web APIs, as well as seeing what the calls actually do. In this post, we will look at how to call the Power BI REST API from Postman. First, follow the instructions here to register an Azure App to use with Power BI. Note the client id and secret. Next, … Continue reading How to Call the Power BI REST API from Postman
In Unified Service Desk, when a user selects a record from a list of records, it’s useful to know which record was selected if you want to route the record in a specific way. Let’s go through an example of what this means and how we can use Entity Search in Windows Navigation Rules to do this. Below I have a list of Contacts in an Account record in USD: … Continue reading Using Entity Search in Windows Navigation Rules to Get the Selected Record in USD
This post comes from a question following on from my Refresh a Power BI Dataset with a Button post which I shared on LinkedIn. The question was, “I wanted to refresh more than one data set in the power bi pro”. You could do this by building out multiple buttons, or you could do this by performing multiple actions within a single flow. You could also do this by calling the … Continue reading How to Refresh Multiple Power BI Datasets using Power Automate and the Power BI API
The Power BI API contains several useful pieces of functionality if you need to do interact with Power BI at a lower API level. Power Automate provides great automation features, and it’s only natural we would want to use the two together. Power Automate does have a Power BI connector, but we can get right to the Power BI API to unlock more features as well. Let’s look at how … Continue reading How to Authenticate and Use the Power BI API inside Power Automate
The Power BI API contains many useful features if you’re looking to interact with Power BI at the API level. In order to use it, we need to register an Azure App first. In this post, we will look at how to do this. There are 2 options of how to register an Azure App – through the Azure portal and through the Power BI service. Let’s start with the … Continue reading How to Register an Azure App to Use with Power BI
In this post, we will look at how to refresh a Power BI dataset using the Power Automate (Flow) mobile app. We previously looked at how to refresh a Power BI Dataset using a Power Apps Canvas App. When using Power Automate, it’s even easier. First, log into Power Automate at https://flow.microsoft.com/. Create a new Instant – from blank Flow: Give the flow a name, e.g. Manually Refresh Power BI Dataset. … Continue reading Refresh a Power BI Dataset with a Button Using the Power Automate Mobile App
Imagine a scenario where your Power BI dataset does not show the latest data, for example, if you are in between a scheduled hourly or daily refresh, and your boss needs to see the latest and greatest data in a Power BI report. And, you’re out on the road. There’s a few ways to solve this problem (in another post I show building a Power Automate button). In this post, … Continue reading Build a Power App Mobile App that Displays and Refreshes your Power BI Data with a Button Click
In this post, we will look at Unified Service Desk Event Parameters that can be used to help with building business logic into your USD apps. Event Parameters are parameters that are populated as a result of a USD event occurring. When used with action calls when events run, they can be used like other parameters in USD. Let’s look at how they work. In my USD environment I have … Continue reading Using USD Event Parameters To Help With Business Logic
In this post we will look at sending input variables and getting output variable responses from an Action in Dynamics 365 Power Apps called through the Web API using Postman. If you haven’t already, set up the Postman client and connect to Dynamics 365 / Power Apps. This can be useful in troubleshooting Web API calls. Under Processes, let’s create a new Action called OutputTest, of entity None (global): In … Continue reading Sending an Input Variable and Getting an Output Variable from a Web API Action Call using Postman
There may be cases where you need to set a lookup field on a Dynamics 365 / Power Apps form, where you want to default the value to another lookup on the form using JavaScript to default the field value. For example, on the Account form, we have the owner of the account (field OwnerId), and we have a custom field called My System User Field (new_mysystemuserfield) which is a … Continue reading How to Set a Lookup Field to Another Lookup Field on a Dynamics 365 Power Apps Form using JavaScript