Easily scale up or scale down your Fabric Capacity using Power Automate (Via email)
Easily scale up or scale down your Fabric Capacity using Power Automate (Via email) Following on from my previous blog post (Stop and start your Fabric Capacity using Power Automate) I got a question from Tristan as shown below! I always enjoy a good challenge and I got it working! In this blog post I will use the same method…
Stop and start your Fabric Capacity using Power Automate
Stop and start your Fabric Capacity using Power Automate With Fabric Capacities trial coming to an end, you need to make sure to stop and start Fabric Capacities. In my blog post below, I am going to show you how I can start or stop my Fabric Capacity by simply sending an email to myself with the details in the…
Refreshing a Power BI Dataset using an HTTPS URL
I have found that sometimes there are other systems that are loading data, and once they are complete they then want to refresh the Power BI Dataset. Another way to do this is to use Power Automate, in which a system or user can request a HTTPS URL and once called that will then refresh the Power BI dataset. I…
Using Power Automate to schedule a refresh of a Power BI dataset at the time you want!
Below are the steps on how to use Power Automate to schedule a refresh of a Power BI dataset at the time you want it to. I have recently seen some questions in the Power BI Community with regards to refreshing Power BI datasets. I thought it would be a good idea to blog on how to use Power Automate…
Exporting a Power BI Visual data to a CSV File in SharePoint
In this blog post I am going to demonstrate how to use the new Power Automate Flow to extract data from a DAX measure into a SharePoint CSV file. I got this idea after reading the blog post from the Microsoft Power BI Team: Unlocking new self-service BI scenarios with ExecuteQueries support in Power Automate | Microsoft Power BI Blog…
Using the Power BI Async REST API to refresh a partition with Power Automate (Using an HTTPS URL)
Welcome to 2022, I am looking forward to an awesome year ahead! With the new awesome feature of now being able to use the Asynchronous refreshing with Power BI Premium/Premium per user I wanted to see if it was possible to use Power Automate to automate the process (Obviously). My goal was to be able to refresh an individual partition…
Power BI coupled with Power Automate allows for super-fast dataset refreshes
I found that using Power Automate to refresh Power BI Datasets allowed for refreshes to happen at the exact time I needed them to. This was because my underlying data warehouse load would vary, by using Power Automate it allowed me to have the Power BI Dataset refresh to happen as soon as my data was ready. By using Power…
Power Platform (Power BI, Power Apps, Power Automate) Announcements from Ignite & SQL Pass
It is that time of the year when there are 2 massive Microsoft conferences happening at the same time. As I have done previously, please find below all the Power Platform announcements with some of my initial thoughts. I do get FOMO at not being at either of them, but thanks to Twitter and other good people there is no…