This is the fourth post in a series of articles in which I explain how to integrate Power BI, Power Apps, Flow, Azure Machine Learning and Dynamics 365 to rapidly build a functioning system which allows users to analyze, insert, automate and action data.
In the previous article I covered building the Power BI Report.
In this article I will cover how to enable data to be pushed into Power BI use Flow. This is a fast no code solution.
This is a one-time setup that is required in order to use the Power BI connector in MS Flow. If you do not do this step you will see an error screen in MS Flow like the screen clip below.
In order to complete this tutorial, you will need permission to register applications in your Azure Active Directory tenant.
For more information on the Azure AD Tenant you can click the following link.
Power BI Development Center
Log onto the Power BI Development Center and enable API features and get the key to register the app in Azure.
Go to the following URL and sign in.
Enter in a meaningful name for your app, I called mine AnthonysPowerBIApp but you can call yours whatever you would like. Choose Native for the Application Type and select Read all datasets and Read and write all datasets for the API Access
Click on Register. A screen like the one below should pop up. Be sure to copy down the Application ID as this is needed to register the application in Azure.
Next log onto the azure portal using the following URL https://portal.azure.com/#home
Once in the portal admin page navigate to the Azure Active Directory menu blade
Next click on App registrations and select the app that we created using the Power BI Development Center.
You can change settings in the app if you whish to tailor it be clicking on Properties.
Now that the Power BI App has been registered in Azure Active Directory you can use it in various Microsoft cloud services such as Flow.
As you can see in the image above, I no longer get a permission error and I am able to select the workspace, dataset and table.
In the next post we will build out the flow so that data is passed from the Power App to an Azure Machine Learning experiment for scoring and then into the Power BI API Enabled Dataset for real-time analytics.
Hopefully you have found this to be another practical post.
Until next time
Here is the official documentation from Microsoft on how to register Power BI to push data into it using REST API calls.