The Power BI Dev Camp session this week is titled Building Solutions using Power Automate and the Power BI REST API. Campers will learn how to build Power Platform solutions with flows and canvas apps that call the Power BI REST APIs to automate common Power BI builder tasks such as importing PBIX files, refreshing datasets and exporting reports to PDF files.
An exciting addition to Power BI April release is Power Automate Visual. This adds a host of capabilities to Power BI directly without relying on Power Apps. Users can now activate PA flows directly at the click of a button from Power BI passing necessary action values. This is not only restricted to operations like Send Mail or Create tasks but could also bring the Powerful Data Manipulation capabilities within Power BI. Here we take up a simple example to show how users can now delete records from Database with a click from Power BI. We were familiar with these SQL actions in Power Automate but there was no way to use them in power BI directly so far without having to use Power Apps. More Power to the platform!!
There is an interesting functionality inside the Power BI Service in which a user can create an alert about a required numeric rule within a visualization. This will give them an early notification about a business process or allow them to keep up to date about specific situations at the exact moment that they occur. In my opinion, the alerts are only comfortable if you have the mobile app, due to instant notification, like a text message, instead of getting an email. Emails are not always checked right away.
The issue here is that all these configurations are only for the user that configures it. However, what can we do when we want to notify other users about the alert created? Power BI won't let you configure another email or user to get this notification. For this reason, we are going to use Power Automate (formerly known as Flow)
Data historians are used throughout industry for mass-long term storage of time series data. There are a number of historians on the market with varying popularity but one thing they tend to have in common is their lack of integration options to popular visualisation tools such as Microsoft Power BI. Until now....
Ever wondered if there might be a better way of navigating around your Power BI reports? In this article we go through all the steps needed use the Power Platform to surface any of your Power BI Reports. It's like a one-inch punch - 1 PowerApps Power BI tile can surface 1000 reports. What's more is that we can refresh our reports at the click of a button by connecting Power Apps to Flow, and Flow to Power BI.
This is the title of a live demo session that demonstrates the Microsoft Power Platform products working together to create an interactive data application. I recently had the honor of presenting this at the Dublin Power BI User Group (@DublinPUG) during my visit to the Power Platform World Tour in Dublin.
In this blog series I will detail all the steps needed to get this demo up and running on your own. I will use the text in this post, as well as screen shots and video's explaining it step by step. So, if you're already (somewhat) familiar with Forms, Power Automate and/or Power BI streaming datasets, feel free to go directly to the video's and start building your own demo right away. Otherwise, keep reading and eventually you'll come across all the resources as well.