Software + Imagination
Power BI reports can be displayed in Power Pages, which is very useful if you want to give your portal users access to the rich reporting features of Power BI. In this post, we will look at how to set up and use Power BI reports in Power Pages. First, we will use some workspaces and reports from this post where we looked at how to use Power BI reports … Continue reading Displaying Power BI Reports in Power Pages
Power BI reports can be surfaced in several ways in Dynamics 365. In this post, we will look at the various options available today in 2024 to display Power BI reports inside of Dynamics 365. Creating a Workspace First, let’s go ahead and create a new Power BI workspace, where we will be housing our Power BI reports. This is done in the Power BI service at https://app.powerbi.com. When you’re in … Continue reading Integrating Power BI Reporting with Dynamics 365 (2024)
Power Automate Flows can now be embedded inside Power BI reports, which opens many possibilities for performing functions within a Power BI report. In this post, we will look at this cool new feature. In a previous post, we showed how to embed a canvas app inside Power BI. Let’s take a look at embedding a flow. Note this functionality will reach General Availability in April 2024 and is part … Continue reading Embedding a Dataverse Power Automate Flow Inside Power BI
Power BI has a visualization that allows us to embed Power Apps Canvas Apps inside of Power BI reports, which can be useful if you want to liven up your Power BI reports! In this post we will create a Power BI report that displays related contact information from a selected account from the Dataverse. This follows on from a similar concept where we embedded a Canvas App inside a … Continue reading Embedding a Dataverse Canvas App Inside Power BI Reports
In this post, we will look at how to embed Power Automate flows inside of Power BI and pass Power BI data to the flows. Let’s say we have a report which contains Dataverse data, and when a user selects an Account, the can click a button to have that account emailed to them. First, let’s look at a Power BI Desktop report we have, which is pulling data from … Continue reading Embedding Power Automate Flows Inside Power BI
Let’s look at how to set up conditional multi-factor authentication (MFA) in Azure AD. This is useful if you want to restrict certain users to use MFA in certain apps in your tenant. First, log into https://portal.azure.com and select Azure AD: Select Security: And select Conditional Access: We will create a new policy: Let’s give it a name, e.g. MFA Conditional Access Policy. We can select to include none, all … Continue reading How to Setup Conditional Access with MFA for Regular and Guest Users in Azure AD
Back in July I blogged about how to create themes in Power BI. Creating your own themes involved creating a JSON file. With the latest Power BI update, we are now able to create themes using the Power BI Desktop UI, as well as export themes so you can share them easily. To enable this feature, go to Options in Power BI Desktop and under Preview features select Customize Current … Continue reading Create, Update and Share Power BI Themes through the Power BI Desktop UI
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
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